Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Grant permission to the profile

The Profiler is a powerful tool available to the dba, but it can also be very useful for system developers. Of course I'm thinking about development environments (production never). Thus, the profiler can help developers monitor the queries and stored procedures developed in the applications.

 

Follow the instruction to grant permission for the execution of profile:

 

//You must be in the master database

USE master

GO

 

GRANT ALTER TRACE TO [username];

Comments

No comments.

Leave a Comment

Please register or log in to leave a comment.