quarta-feira, 16 de janeiro de 2013

Scrip Para Encontrar o CD Key do SQL

SQL SERVER – T-SQL Script to find the CD key from Registry

Here is the way to find SQL Server CD key, which was used to install it on machine. If user do not have permission on the SP, please login using SA username. Expended stored procedure xp_regread can read any registry values. I have used this XP to read CD_KEY. This is undocumented Stroed Procedure and may not be supported in Future Version of SQL Server.
USE master
GO
EXEC xp_regread 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Microsoft
SQL Server\80\Registration'
,'CD_KEY'
GO

Reference : Pinal Dave (http://blog.SQLAuthority.com)

Fonte: http://blog.sqlauthority.com/2007/02/28/sql-server-t-sql-script-to-find-the-cd-key-from-registry/ 

OBS: Pode-se encrontrar também indo pelo registor (regedit)

Nenhum comentário: