Need SQL2016 Help

twitter logo github logo ・1 min read

I need some urgent assistance from the community: I need a way to list failing transactions from a sql2016 database, without altering code or data.

I've searched hi and low on Google and all my references and cannot see a way.


I inherited a set of databases whi ch are suffering from 10y of 'deferred maintenance', 'shove it in for deployment', and no maintenance plan at all other than backups.

My current situation is we have a serious deadlock/transaction failure scenario that is eating our lunch and for reasons I don't want to get into, I have no way of determining what code or sp is breaking other than to find the transactions that failed and look at the context.

Thanks in advance

twitter logo DISCUSS (2)
markdown guide

Hi John, can I suggest adding the #help tag to your post? That way it will appear on the sidebar of everyone's home page and be more visible to folks who can help :)

Classic DEV Post from Sep 27 '18

Some tips to improve your life

For some time now I've been looking for and researching ways to improve my life...

John 'BBQ' Wollner profile image
I hate bio's because I have a hard time describing myself. I'm a 60's coder who started with computers in 1982 and just kept going. I went from tech school to VP of IT and back down to code, to stay