Home Forums Article Discussions Article Discussions by Author Discuss content posted by Ian Stirk What SQL Statements Are Currently Executing? RE: What SQL Statements Are Currently Executing?

  • April 6, 2010 at 9:03 pm

    #1146962

    ianstirk (4/6/2010)

    Hi Jason,

    I'm glad you liked the article.

    There is an updated version of this script, without the deprecated objects, given in the book I am writing "SQL Server DMVs in Action". You can get the first chapter free here: http://www.manning.com/stirk

    Thanks

    Ian

    That's cool.

    I took the liberty of creating a script similar in nature that I use in place of sp_who2.

    I will be posting that script to the web soon.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events