Question:
I have a team that would like to use the PROFILER to monitor the underlying TSQL statements to fine tune the database. How to enable this for the users without granting any Administrative privileges such as DBOon that database.
Solution:
Running SQL Server Profiler requires the same user permissions as the Transact-SQL stored procedures that are used to create traces. To run SQL Server Profiler, users must be granted the ALTER TRACE permission. For more information, see GRANT Server Permissions (Transact-SQL).
]]>