Read the registry using T-SQL

,

This script uses the extended stored procedure xp_instance_regread to read a value from the registry

DECLARE @retvalue int, @data_dir varchar(500)
EXECUTE @retvalue = master.dbo.xp_instance_regread 'HKEY_LOCAL_MACHINE',
'SOFTWARE\Microsoft\MSSQLServer\Setup',
'SQLDataRoot', @param = @data_dir OUTPUT
PRINT 'SQL Server Data Path: '+ @data_dir

Rate

5 (2)

Share

Share

Rate

5 (2)