Very nice query! It's also in my bag of tricks now and actually opened my eyes to who actually has access to instances on a server I inherited. Time to...

Nice writeup!

I'm moving past the novice DBA stage and have been use the .trn extension on all transaction log backups for past few years. Is there a good case for...

Good to know, thanks. 🙂

If you are using SSMS from your desktop, I've noticed that you cannot manage maintenance plans. How would you do that in this scenario?