Posted by SQL Enthusiast
Article by our editor
Sometimes it is useful to see what is currently running on a SQL server. On SQL Server 2005 and later this is fairly easy to achieve using the Dynamic Management View (DMV) dm_exec_requests.
Comments (3) • Read full article »
The stored procedure xp_readerrorlog (and also sp_readerrorlog) allows searching of the SQL Server error logs. However only one log can be searched at a time. This script searches all available logs, by looping through each log in turn.
Comments • Read full article »
More SQL questions »