Wednesday, March 28, 2018

Grant ability to execute sp_who and sp_who2 without granting sysadmin privileges

Subhash Chandra  over at Sql Server Central has written what appears to be a great little procedure for granting someone the ability to run sp_who and sp_who2 without granting them sysadmin privileges.

Grat sp_who2 & who3 without granting sysadmin privileges

I have literally nothing to add :-D  Posting it here mostly so I can easily find it later.  Thanks, Subhash.

Get Restart log using PowerShell

I'm often curious about a restart on a Windows server system. An easy way to get a list of the restart and what initiated it is to use t...