Post reply

Identifying own session''s process_id

  • May 30, 2006 at 7:55 am

    #114382

    Does anybody know if a session running a T-SQL script can identify its own process ID - and if it can, then how?

    I'm trying to assemble a script that will list all the locks across all the databases on a given server; but I want to exclude any locks put on by the process running the script.

    If anybody has any ideas, please let me know ASAP?

    Regards

    Dave.

  • May 30, 2006 at 8:11 am

    #640693

    @@SPID this will return the process id. Bung a 'and processid != @@SPID' in your where

    clause(s)

    www.sql-library.com[/url]

  • May 30, 2006 at 8:30 am

    #640703

    Jules

    Many thanx for that - worked a dream.

    David.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply