Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

SqlServerZest.com - SQL in simple style

Suresh Raavi is a database professional, with a zest for SQL Server specializing in Administration and performance tuning. Presently, he is a Sr. SQL Server DBA at the Microsoft Products and Services IT SQL team, taking part in various challenging projects, focusing mainly on performance tuning, database development, high availability and database design. He is passionate about database technologies and "data" in general. He has earned the MCITP Database Administrator 2008, and holds a Master of Science degree in Engineering. He provides insights from the field on his blog at http://SqlServerZest.com. His hobbies includes Running and Travelling. You can follow him on Twitter @SqlServerZest

SQL Server – How to Search/Query the SQL Server Error Log

Often times I keep checking the error log to make sure if everything is running fine. Here is an undocumented stored procedure that really helps simplify our task of searching the error log. Exec XP_ReadErrorLog GO This proc has 4 parameters: Parameter 1 (int), is the number of the log file you want to read, default […]

Comments

Leave a comment on the original post [sqlserverzest.com, opens in a new window]

Loading comments...