SQLServerCentral / Discuss Content Posted by Wesley Brown / Article Discussions / Article Discussions by Author / alert on blocking chains via email / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 23 May 2013 18:15:41 GMT20RE: alert on blocking chains via emailhttp://www.sqlservercentral.com/Forums/Topic408080-195-1.aspxWesley,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 131String or binary data would be truncated.Any ideas? Thanks,D.Q. Sr. DBAThu, 12 Jan 2012 14:29:17 GMTdemico_quinnRE: alert on blocking chains via emailhttp://www.sqlservercentral.com/Forums/Topic408080-195-1.aspxThanks, this is a good find for waittype's!Tue, 05 Aug 2008 09:13:43 GMTAndrew Peterson-472853alert on blocking chains via emailhttp://www.sqlservercentral.com/Forums/Topic408080-195-1.aspxComments posted to this topic are about the item [B]<A HREF="/scripts/Miscellaneous/31157/">alert on blocking chains via email</A>[/B]Mon, 08 Oct 2007 10:07:54 GMTWesley Brown