SPID in eventinfo

• balbirsinghsodhi

  SSCrazy Eights

  Points: 9210

  More actions

  July 1, 2008 at 4:04 pm

  #123600

  Question.

  How does SPID got assign to the process. ?

  Let's say I started a process and captures SPID in a table and next time I run the same process, will the same SPID assigned to the same process.

  If not then how to capture eventinfo using DBCC INPUTBUFER(SPID) into a table.

• MannySingh

  SSChampion

  Points: 12465

  More actions

  July 1, 2008 at 6:49 pm

  #836961

  is this what you need:

  select st.text, * from master..sysprocesses

  cross apply sys.dm_exec_sql_text(sql_handle) st

  OR select st.text,ec.* from sys.dm_exec_connections ec

  cross apply sys.dm_exec_sql_text(most_recent_sql_handle) st

  Maninder
  www.dbanation.com