• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 391
  • Last Modified:

Correlate SPID to session_id

I need to find out what session_id a given SPID is correlated to.  I currently have a profiler trace running that inserts session_id values into a table (I wish it just inserted SPIDs).  It only displays session_id, so I am hoping there's a way to correlate the two values.

I need SPIDS.

Any ideas?
0
IntercareSupport
Asked:
IntercareSupport
2 Solutions
 
Aneesh RetnakaranDatabase AdministratorCommented:
session_id is the same as spid  
0
 
chapmandewCommented:
theyre the same thing.  spid is what the session used to be called in 2000 and before...now it is just session id
0
 
IntercareSupportAuthor Commented:
Thanks a lot!
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now