SPID and ClientProcessID

What's the difference for SPID and ClientProcessID in SQL 2008 Profiler ? After I stop the process, can I filter the result by SPID ?

Tks
AXISHKAsked:
Who is Participating?
 
Eugene ZConnect With a Mentor Commented:
yes, you can sort by SPID



ClientProcessID:
 ID assigned by the host computer to the process where the client application is running. This data column is populated if the client process ID is provided by the client.  


SPID:
Server Process ID assigned by SQL Server to the process associated with the client.

more:
SQL Profiler Data Columns
http://technet.microsoft.com/en-us/library/aa173882(v=sql.80).aspx
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.