SQL Server Trace (aka SQL Profiler) Priveliges without giving sysadmin
I’m a big proponet of using SQL Server Profiler for monitoring DB activity from applications. When a client has a SQL Server DBA on staff, they continuously tell me they can’t grant me Trace privileges without giving me sysadmin privileges. Oh yes they can! Below is the simple script to grant a particular user trace privileges without granting sysadmin (god access).
GRANT ALTER TRACE TO [useridhere];