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?
Asked
Active
Viewed 64 times
-1
-
I have a full script that you can use with proper credit - https://dba.stackexchange.com/a/41622/8783 – Kin Shah Sep 26 '18 at 18:39
1 Answers
0
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
Tibor Karaszi
- 17,101
- 2
- 14
- 26