Read the registry through Xp_regread extended stored procedures:Įxec xp_regread 'HKEY_LOCAL_MACHINE', 'SOFTWARE \ Microsoft \ Microsoft SQL Server \ 100 \ Tools \ Setup', 'ProductCode'Įxec xp_regread 'HKEY_LOCAL_MACHINE', 'SOFTWARE \ Microsoft \ Microsoft SQL Server \ 100 \ Tools \ Setup', 'DigitalProductID'Įxec xp_regread 'HKEY_LOCAL_MACHINE', 'SOFTWARE \ Microsoft \ Microsoft SQL Server \ 110 \ Tools \ Setup', 'ProductCode'Įxec xp_regread 'HKEY_LOCAL_MACHINE', 'SOFTWARE \ Microsoft \ Microsoft SQL Server \ 110 \ Tools \ Setup', 'DigitalProductId'ĭon't be fooled by ProductCode, even if only the SQL Server client is installed, this key will be in the registry, not the serial number, DigitalProductID is, but after Base24 encoding, decoding is required. ![]() MSDN Subscriptions Download the installation package is a built-in serial number, there is no such trouble. When you need to install SQL Server again, if the serial number is not found, you can try to retrieve the serial number from the installed instance, because after the installation of SQL Server, the serial number (Product Key) is stored in the registry
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |