Skip to content
«
»
 

Get Session ID

Posted by 
on  May 28 2010

To get the session ID, simply use the intrinsic variable @@SPID:

SELECT @@SPID

The acronym for SPID means Server Process ID. It is synonymous with session.



Popular search terms:
Filed under TSQL
Comment (RSS)  |  Trackback  |  Permalink

One Comment

  1. Ben says:
    July 14, 2011 at 10:43 pm

    whenever I rebuild index on SQL 2008, my process is blocked by session id -2. I could not find where this process is.

    Need your assistance badly.

    Thanks.
    Ben

    Reply to this comment

post a comment OR Post Your Question on our ASK! Community!

«
»