Get the proc name from a deadlock alert
The Alert gives objectId and databaseid but your average 'accidental DBA' doesn't know the command
select OBJECTNAME ( objectid [, database_id ] )
Perhaps somehow suggesting the command as context sensitive help?
30
votes
bob
shared this idea
-
Taqveem Khalid
commented
Or maybe surfacing the object_name within the alert. Seeing an actual SP name as opposed to a system generated number would really help visualise which database objects are involved.
-
Ray Herring
commented
There are a number of other enhancements possible. For example, it would be nice to have table or index name.