How to check the errorlogs for any errors?

Question

How to check the errorlogs for any errors?

san43

Hall of Fame

Points: 3196
More actions
March 23, 2006 at 3:40 am

#116652

How to check the error logs for any errors using a query?

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Yelena Varshal SSC-Dedicated Points: 34286 More actions · Answer 1

Events from the SQL Server Logs are mostly in the Windows Event Log that you may query with the help of WMI query. See examples at:

http://windowssdk.msdn.microsoft.com/library/default.asp?url=/library/en-us/wmisdk/wmi/wmi_tasks__event_logs.asp

WMI Tasks: Event Logs

Regards,Yelena Varsha

MG-148046 SSCrazy Eights Points: 9946 More actions · Answer 2

To read the current SQL error log, you could use xp_readerrorlog. Dump the ouptput into a temp table and examine it for keywords. The output of the xp is a littel different between 2000 and 2005 so you would need to modify your query or sp to match.

MG

"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare

"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.

san43 Hall of Fame Points: 3196 More actions · Answer 3

I am getting the result as many rows but I only need rows showing errors.

Patrick Folan Mr or Mrs. 500 Points: 512 More actions · Answer 4

Try this command from QA, with the correct path for your error log location, and look for the keywords you want such as warning , log full etc...

EXEC sp_readerrorlog 1, "C:\Program Files\Microsoft SQL Server\MSSQL\LOG\ERRORLOG", 4, 'warning'