no problem,you can try:xp_regread Xp_regread lets you read the values that subkeys, such as BackupDirectory, contain:DECLARE @backupdir varchar(255) EXEC master.dbo.xp_regread 'HKEY_LOCAL_MACHINE', 'SOFTWARE\Microsoft\MSSQLServerMSSQLServer', 'BackupDirectory',@backupdir OUTPUT
Xp_regread lets you read the values that subkeys, such as BackupDirectory, contain:DECLARE @backupdir varchar(255)
EXEC master.dbo.xp_regread 'HKEY_LOCAL_MACHINE',
'SOFTWARE\Microsoft\MSSQLServerMSSQLServer',
'BackupDirectory',@backupdir OUTPUT