How can I show SQL Server LOGS (2005)
I am trying to track down a bug released by SQL Server 2005. The problem is that SQL Server reports this in my native language, so I am having a hard time doing it.
I think the main issue will be available in English in SQL Server LOGS. I run SQL Server Management Studio Express by going to the "Management" node and then SQL Server Logs. I see a list of logs but I cannot enter them, the only available option in the context menu is Refresh.
Could you help me show the contents of these logs?
a source to share
I don't think Studio Management Express Edition can display ERRORLOG. An alternative is to open the ERRORLOG file in notepad, as well as a plain text file, usually located in the \ Program Files \ Microsoft SQL Server \ MSSQL.EXPRESS \ MSSQL \ LOG folder
Another option is to open a query window and do the following:
exec xp_readerrorlog;
a source to share