Comments posted to this topic are about the item alert on blocking chains via email
Thanks, this is a good find for waittype's!
The more you are prepared, the less you need it.
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.
D.Q. Sr. DBA
Viewing 3 posts - 1 through 2 (of 2 total)