SQL SERVER MONITORING: SQL Server Read Error Log from SSMS
Reading the error log of any sql server instance using SQL Server Management Studio is absolutely very simple task and many technicians even don’t know about it. I though to let you all know about it, here is the statement:
EXEC sp_readerrorlog 0
–
–
So, with the aforementioned system stored procedure you can easily view the error log of the connected instance.