sp_who2 Alternative (T-SQL, SQL Server)

The trusty “sp_who2” is a quick way to look at what’s happening on your SQL instance, but completely lacks the ability to filter using a WHERE clause. You may have to manually sift through hundreds of results to find what you need.

Never fear.

This quick script gives you the same basic output that sp_who2 gives, except you can throw a filter on the results with the WHERE clause.

This site uses Akismet to reduce spam. Learn how your comment data is processed.