Alert Negative SPID

• Pouliot Philippe

  SSCommitted

  Points: 1912

  More actions

  December 21, 2010 at 12:58 pm

  #144345

  Hi everyone, Any suggestion for i got a alert when negtaive SPID(-2) was raise on my Server ?

  Thanks.

• Cath Trimble

  SSCarpal Tunnel

  Points: 4201

  More actions

  December 22, 2010 at 4:12 am

  #1265422

  Does this help? http://netic.wordpress.com/2010/03/26/negative-spid-in-sql-server/

• Pouliot Philippe

  SSCommitted

  Points: 1912

  More actions

  December 22, 2010 at 5:59 am

  #1265458

  Yes and No. I Look for an automatic notification when this case raise, but i think I can Use this code

  select COUNT(*)

  FROM msdb.sys.syslockinfo

  WHERE req_spid<0

  With a verification every 1hrs.

  Thanks.:-)