In order to run a trace against SQL Server you must be a member of sysadmin fixed server role or hav...

SQL用PROFILER时产生的权限问题。不用大开到SYSADMIN的权限吧。

用以下方法完美解决。只给TRACE权限。

 

SQL Server Profiler and ALTER TRACE permission

Yesterday, I wanted to use SQL Server Profiler to check what was happening on the database side of an application I am developping. However, SQL Srever Profiler was giving me the following error message:

In order to run a trace against SQL Server you must be a member of sysadmin fixed server role or have the ALTER TRACE permission.

In order to resolve this, you need to issue the following SLQ query in the master database:

GRANT ALTER TRACE TO username

Replace username by the username you want to use to access the database in SQL Server Profiler.