CODEWITHSUNDEEP
sql-serversql-server-2005exception
Marcin Rybacki
Marcin Rybacki

Reputation: 1024

How can I show SQL Server LOGS (2005)

I'm trying to track the error thrown by SQL Server 2005. The problem is SQL Server reports it in my native language so it's hard for me to google it.

I think that the core issue would be avialable in English in SQL Server LOGS. I'm running SQL Server Management Studio Express, going to "Management" node, and then SQL Server Logs. I can see the list of logs but I cannot enter them, the only available option in context menu is Refresh.

Could you help me to show the contents of those logs?

Upvotes: 2

Views: 5035

Answers (2)

Remus Rusanu
Remus Rusanu

Reputation: 294457

I don't think the Express version of the Management Studio can show ERRORLOGs. The alternative is to open the ERRORLOG file in notepad, as is an ordinary text file located usually in \Program Files\Microsoft SQL Server\MSSQL.EXPRESS\MSSQL\LOG

Another alternative is to open a query window and execute this:

exec xp_readerrorlog;

Upvotes: 3

Raja
Raja

Reputation: 3618

Check this out:

http://www.mssqltips.com/tip.asp?tip=1021

HTH

Upvotes: 0

Related Questions