alert on blocking chains via email

  • Wesley Brown

    SSChampion

    Points: 12045

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

    http://www.sqlserverio.com
    http://www.cactuss.org
    http://www.salssa.org

  • Andrew..Peterson

    SSCertifiable

    Points: 6837

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

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

  • demico_quinn

    Grasshopper

    Points: 23

    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