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.
Subscribe to:
Post Comments (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 ...
No comments:
Post a Comment