alert on blocking chains via email

• Wesley Brown

  SSChampion

  Points: 12045

  More actions

  October 8, 2007 at 10:07 am

  #175797

  Comments posted to this topic are about the item alert on blocking chains via email

• Andrew..Peterson

  SSCertifiable

  Points: 6838

  More actions

  August 5, 2008 at 9:13 am

  #853251

  Thanks, this is a good find for waittype's!

  The more you are prepared, the less you need it.

• demico_quinn

  Grasshopper

  Points: 23

  More actions

  January 12, 2012 at 2:29 pm

  #1432897

  Wesley,

  I'm using SQL 2005 and have installed the blocking e-mail alerting based off of your article. But when it detects a blocking issue it fails on tryning to insert into #Active_spids. I've increased the column sizes on all temp tables but I'm still getting this error:

  Msg 8152, Level 16, State 2, Line 131

  String or binary data would be truncated.

  Any ideas?

  Thanks,

  D.Q. Sr. DBA