• When I cut and pasted the first procedure into a new query window and attempted to execute, I got a whole series of syntax errors:

    Msg 102, Level 15, State 1, Procedure usp_DeadlockNotification, Line 5

    Incorrect syntax near '='.

    Msg 137, Level 15, State 2, Procedure usp_DeadlockNotification, Line 28

    Must declare the scalar variable "@Filter".

    Msg 137, Level 15, State 2, Procedure usp_DeadlockNotification, Line 31

    Must declare the scalar variable "@Minutes".

    Msg 156, Level 15, State 1, Procedure usp_DeadlockNotification, Line 38

    Incorrect syntax near the keyword 'ELSE'.