October 8, 2007 at 10:07 am
Comments posted to this topic are about the item alert on blocking chains via email
August 5, 2008 at 9:13 am
Thanks, this is a good find for waittype's!
The more you are prepared, the less you need it.
January 12, 2012 at 2:29 pm
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
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy