Show the database name not just dbid in the Lock Details of a Deadlock alert

I've got to do the extra step of:

SELECT name,dbid
FROM master..sysdatabases

to figure out which database the deadlock is referring to... shouldn't have to do this.

71 votes

Paul E. shared this idea · Nov 14, 2011 · Report… · Admin →

completed ·

Adam responded · Jan 22, 2014

Database name is now shown for 2005+ deadlock alerts following the v4 release.

Thanks again for the suggestion and votes.

An error occurred while saving the comment

AdminAdam (User Experience Specialist, Red Gate Software) commented · January 22, 2014 6:57 AM · Report

Thanks Blaž, we can confirm this is now shown for 2005+ deadlock alerts.

Adam

Submitting...
Blaž Dakskobler commented · January 22, 2014 5:21 AM · Report

This was done in v4.0, wasn't it?

Submitting...
AdminPriya Sinha (Project Manager, Red Gate Software) commented · August 17, 2012 1:06 AM · Report

Hi,

Thanks for your feedback. We would definitely try to improve this.

Thanks,
Priya

Submitting...

In SQL Monitor, I want to...