Bru Medishetty's SeekWell Blogs
View SQL Server Error Logs through T-SQL
When SQL Server error log is not initialized at a regular interval causing the error log file to grow into a huge file. Viewing that in the SQL Log File Viewer would be a time consuming task.
This article will show how to view the SQL Server error log from a query analyzer in 2000 or query editor in later versions. As an additional benefit this code filters the log file and displays only the past 24 hours (default code).
To view SQL Server error logs in SQL Server 2000
To view SQL Server error logs in SQL Server 2005 / 2008
The script can be changed to display only data for the past n # of hours by changing the value of @Hours.
–Bru Medishetty
| This entry was posted by Brumedishetty on December 1, 2009 at 12:00 AM, and is filed under SQL Server. Follow any responses to this post through RSS 2.0. You can leave a response or trackback from your own site. |
about 4 months ago
Hello! interesting site!
about 4 months ago
found your site on del.icio.us today and really liked it.. i bookmarked it and will be back to check it out some more later