Skip to content

How to Grant Read-Only Access to Activity Monitors

sql server management services

Give your clients the ability to view activity monitor, without handing over full sys-admin rights into your managed SQL server environments;

use [master]
GO
GRANT VIEW SERVER STATE TO [DomainUsername]
GO

SHARE THIS POST: