Home Forums Article Discussions Article Discussions by Author Discuss content posted by Geoff Albin How to receive Deadlock information automatically via email. RE: How to receive Deadlock information automatically via email.

  • July 12, 2012 at 4:45 am

    #1511971

    u need to add (deadlock-list) in ----> Like ''''%Deadlock encountered%''''

    in the below query.

    @query = ''select logdate, procInfo, ERRORLOG from tempdb.dbo.ErrorLog where Id >= (select TOP 1 Id from tempdb.dbo.ErrorLog WHERE ERRORLOG Like ''''%Deadlock encountered%'''' order by Id DESC)'',

    the correct query -

    @query = ''select logdate, procInfo, ERRORLOG from tempdb.dbo.ErrorLog where Id >= (select TOP 1 Id from tempdb.dbo.ErrorLog WHERE ERRORLOG Like ''''%deadlock-list%'''' order by Id DESC)'',

    the reason behind this is the deadlock grap is not on in your production server .