May 5, 2010 at 1:08 am
Hi,
Is there any query to find out the path of the sql server error log file location like how we are getting the database files by using query (select * from sys.database_files ) ?
Thanks in Advance.
May 5, 2010 at 1:43 am
master..xp_readerrorlog will list out the error logs.
May 5, 2010 at 2:07 am
BEGIN
DECLARE @path NVARCHAR(4000)
EXEC master.dbo.xp_instance_regread
N'HKEY_LOCAL_MACHINE',
N'Software\Microsoft\MSSQLServer\MSSQLServer\Parameters',N'SQLArg1',
@path OUTPUT,
'no_output'
print @path
END;
May 5, 2010 at 3:32 am
moorthy.jy (5/5/2010)
master..xp_readerrorlog will list out the error logs.
but wont show the error log location/path .
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply