You must have the privileges listed below to access SQL Expert functions and modules. You must have sa_role to:
Use the SQL Collector for Monitor Server module
Terminate the Run Result function when the SQL statement produces a result set in the SQL Optimizer and SQL Worksheet modules
Access the dbcc traceon information
To optimize a SQL statement that is used in a cursor in the Syntactical SQL Optimizer, you must have the privilege to create a procedure.
