Posted by SQL Enthusiast
Article by our editor
Sp_who2 is one of the most useful and widely used stored procedures, along with its predecessor sp_who. However it is also one of the most frustrating as it only takes a single parameter and the results cannot be ordered. For a large server with a lot of connections this can be a real nuisance. This article explains how to sort and filter the results.
Comments (26) • 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 »
© 2010 - 2017. All Rights Reserved. Design by