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.
Wednesday, March 28, 2018
Subscribe to:
Posts (Atom)
The Database is not accessible after creating Always On Availability Group
Having created a fully functional SQL Server Always On Availability Group, I connect using SSMS. Upon trying to expand the database, I get ...
