Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2004
    Location
    Calgary, Alberta
    Posts
    106

    Unanswered: SA user logging off and on again w/ same spid

    Hey all,

    I've got a third party app running atop my sql server instance. When auditing logons in profiler, I see that the user (sa) logs off, and then immediately logs back on. Interestingly, the app logs back on with this user again, and the instance gives it the same spid as it previously had.

    Can anyone explain this behaviour, or point me to a place where I can investigate ?

    Thanks,
    -Kilka
    There is nothing more helpless and irresponsible than a man in the depths of an ether binge. -HST

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    A spid is a process identifier. They are simply unique numbers assigned to whatever client-server connections are created to a SQL instance. SQL Server always reuses spids (otherwise the spids would quickly become huge), so it is quite common for the last spid used by a released connection to be quickly reused by another (new) connection.

    -PatP

  3. #3
    Join Date
    Aug 2004
    Location
    Calgary, Alberta
    Posts
    106
    thanks pat!
    There is nothing more helpless and irresponsible than a man in the depths of an ether binge. -HST

Posting Permissions

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