sql solace
Thursday, 26 March 2009
Developer Permissions TSQL
to view activity monitor >
USE MASTER; GRANT VIEW SERVER STATE TO [username]
to run profiler >
USE MASTER; GRANT ALTER TRACE TO [username]
to view execution plans >
USE DBNAME; GRANT SHOWPLAN TO [username]
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment