Is it possible to send queries involved in a deadlock via db mail alert in SQL Server 2005 on mail?

If it is possible, then what is the best way to do this?


1 Answer 1


Perhaps using Event Notifications, and have the queue reader send email using sp_smtp_sendmail? https://itsalljustelectrons.blogspot.com/2017/06/Handling-SQL-Server-Deadlocks-With-Event-Notifications.html

Not the answer you're looking for? Browse other questions tagged or ask your own question.