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
![](https://secure.gravatar.com/avatar/4656ea0f0f6e34246a03ec928cfb3c76?size=40&default=https%3A%2F%2Fassets.uvcdn.com%2Fpkg%2Fadmin%2Ficons%2Fuser_70-6bcf9e08938533adb9bac95c3e487cb2a6d4a32f890ca6fdc82e3072e0ea0368.png)
-
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.