declare @sqlProductVersion sql_variant declare @sqlProductLevel sql_variant declare @sqlEdition sql_variant declare @sqlLicenseType sql_variant declare @sqlNumLicenses sql_variant select @sqlProductVersion = SERVERPROPERTY('productversion') select @sqlProductLevel = SERVERPROPERTY('productlevel') select @sqlEdition = SERVERPROPERTY('edition') select @sqlEdition = SERVERPROPERTY('LicenseType') select @sqlEdition = SERVERPROPERTY('NumLicenses') EXEC master..xp_regwrite @rootkey='HKEY_LOCAL_MACHINE', @key='SOFTWARE\SQLInfo', @value_name='SQL Product Version', @type='REG_SZ', @value=@sqlProductVersion EXEC master..xp_regwrite @rootkey='HKEY_LOCAL_MACHINE', @key='SOFTWARE\SQLInfo', @value_name='SQL Product Level', @type='REG_SZ', @value=@sqlProductLevel EXEC master..xp_regwrite @rootkey='HKEY_LOCAL_MACHINE', @key='SOFTWARE\SQLInfo', @value_name='SQL Edition', @type='REG_SZ', @value=@sqlEdition EXEC master..xp_regwrite @rootkey='HKEY_LOCAL_MACHINE', @key='SOFTWARE\SQLInfo', @value_name='License Type', @type='REG_SZ', @value=@sqlLicenseType EXEC master..xp_regwrite @rootkey='HKEY_LOCAL_MACHINE', @key='SOFTWARE\SQLInfo', @value_name='License #', @type='REG_SZ', @value=@sqlNumLicenses set @sqlProductVersion = NULL set @sqlProductLevel = NULL set @sqlEdition = NULL set @sqlLicenseType = NULL set @sqlNumLicenses = NULL