Morning

What to do with questions like this?

@Colin'tHart I understand the dilemma. It's an interesting topic for sure. However, there's no simple, practical question which can be answered. I can see how it may be considered "shopping list" but I read it as an honest inquiry into the workings of a DBMS. I wouldn't vote to close.

@HannahVernon I was not referring to anything specific - just me kinda showing my general dissatisfaction with the offhand way in which the community has been treated by SE! I find it difficult to comprehend how they can be so cavalier with their most precious resource - those who volunteer considerable amounts of time to queue reviewing and other (thankless apparently) tasks on the site.

Why were we not asked what we thought about the idea of removed the "last seen" widget - which I found very handy? When reviewing queues for example, I could check to see if the person had seen a request for more information and act accordingly.

@HannahVernon how can I use OUTPUT to return the affected rows?

@PaulWhite and here we have an example of an accepted answer that has been approved by OP and not the answer with the most upvotes: How to know which application or user put the SQL Server Database in single user mode

I'd just like to mention it, because a lot of people think extended events are the solution and as soon as some person with a certain amount of reputation writes an answer, then everybody thinks, it has to be the solution.

SQL Server Audits are the replacement for the C2 features which are deprecated.

Morning

Morning

morning