Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2004
    Location
    Cergy
    Posts
    65

    Question Unanswered: sessionid in Query Analyser

    I want to know my session id number in Query Analyser

    Do you know a procédure or a command ?

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Do you mean the server process identifier

    SELECT @@SPID
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  3. #3
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    Query Analyzer also has the SPID in the bottom of the query window, next to your login name.

  4. #4
    Join Date
    Dec 2002
    Posts
    1,245
    [QUOTE=nanou9999]I want to know my session id number in Query Analyser

    like...wow...i...must...be...really...slow

    Gotta get some coffee.

    Regards,

    hmscott
    Last edited by hmscott; 09-30-05 at 16:58.
    Have you hugged your backup today?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •