Give Access to check Activity monitor and to run SQL Profiler for non sysadmin login.

Need to get permission on the server that will enable to see the activity monitor and to work with the SQL Server Profiler on sql server.

Those permission are needed for testing the work done on the Test DB
How to give access to check Activity monitor?

USE master;

How to give access to run Sql Profiler on the server to one windows login i.e. non sysadmin?

USE master;
GRANT ALTER TRACE TO [windowslogin]


Security tab --> Logins --> right click name to modify select properties --> Securables tab --> Click add --> Select the server you want to add the permissions to. The permissions should appear in the effective permissions list

You need to check the Grant column for the required permissions.


  1. Just want to say your article is as astounding.

    The clarity in your submit is just spectacular and that i can think
    you're knowledgeable in this subject. Well along with your permission let me to grab your RSS feed to stay updated with drawing close post.

    Thanks 1,000,000 and please continue the rewarding work.

    Review my web-site ... weight loss programs (


Post a Comment

Popular posts from this blog

SQL Server:Steps to Configure Database Mirroring by T-SQL Script.

SSIS2008R2 Error: 0xC0209303 at Package: