how to check the default path for the data and log file for MSSQL2000?
coz i got some problem when trying to 'hard code' the path, it said can't find the specified path
thanks
Printable View
how to check the default path for the data and log file for MSSQL2000?
coz i got some problem when trying to 'hard code' the path, it said can't find the specified path
thanks
from this linkCode: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