Used to use this more in the past, but rarely use it now. Had to check something for someone recently, so decided this was good knowledge.

Apologies for the explanation. That is updated.
For the  result set answer, expanded to note the answer is a multi-line result set.

Technically, @@options returns an integer. You can...

Thanks. I find XE cumbersome, but I am trying to fix that, or at least learn how to work with it better.

XE is a tracing system that can capture all activity occurring in SQL Server. This replaces SQL Trace/Profiler, which is a more heavyweight way of gathering activity. SQL Trace also...

I bet it was. Lots of work being done at MS on GDPR compliance.

Go for it, Angel. So far haven't seen a good basic for the latest version.

OK, it's too semantic. Reworded the question and awarded points back.

Eric,

Do you track some logins, Linked servers, with this as well? Those server level objects are often just maintained by DBAs, but easy to forget that audits,...