read error log through sql?

can you query the attached info from sql server? (this is on a dedicated SQL Server 2008)
Who is Participating?
Tony303Connect With a Mentor Commented:
You can call the Log file number like this...

 exec sp_readerrorlog 1

1 being the 1st log file.

Here is an SP that will give you "query" ability as well..
Sagir87Connect With a Mentor Commented:
Hi ,

1. You can also query in query analyzer as given below :

exec sp_readerrorlog

2. If you want detail information you can open error lo g file in notepad in your default location:

C:\Program Files\Microsoft SQL Server\MSSQL10.SQL2008\MSSQL\LOG


C:\Program Files(x86)\Microsoft SQL Server\MSSQL10.SQL2008\MSSQL\LOG
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.