Getting the SPID of a SqlConnection

  • Thread starter Thread starter Paul
  • Start date Start date
P

Paul

Is there a way to get the SPID at runtime (the server-side
connection/process ID, which you can see in the
management/current_activity/process_info area in Enterprise Manager) from an
active SqlConnection object? I have found zero related info in help, object
browser, or the API viewer. Is getting it directly impossible?

Paul
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Getting SPID from SqlConnection 3
Again, with the SqlConnection in Session variable 2
How to get a SQLConnection string from an ODBC DNS? 4
Getting a Timeout in my SQLConnection 2
Howto obtain the credentials from a SqlConnection object 3
SqlConnection opens tons of connections 6
The age of a web page 5
SqlClient Connections created don't get reused in the pool and causeerror in ASP.NET Page 16

Back
Top