Reading the error log

 hi,

I use this below stored procedure and copy and paste in text editor and search for " Error "  

EXEC xp_readerrorlog 

we can also go under- management -sql server logs and check
every time sql server is restarted a new log is created


also
EXEC sp_cycle_errorlog--- will create a new one and delete oldest one 
like wise for SQL Agent
EXEC sp_cycle_agent_errorlog ----  will create a new one and delete oldest one
----Closes the current error log file and cycles the error log extension numbers just like a server restart.




Thanks