SQL Profiler Access in SQL SERVER 2005/2008

In SQL Server 2005/2008 the good feature is a SQL User can run the PROFILER or Trace without having SYSADMIN Privilege.

As per Volume Data policy Developer doen’t have SYSADMIN priviledge on UAT&LIVE SQL Instances.

At the same time few developers might be interested to perform same using SQL Server Management Studio (SSMS).

Below are the steps to accomplish this task without giving SYSADMIN privilege.

SSMS àunder Security tab à Logins à right click name to modify select properties à securables tab à Click Search à Select the instance you want to add the permissions to. à Grant ALTER TRACE permission.

The permissions appear in the Effective Permissions list

-------------------------------------------------------------------------------------------

But this privilege revoked automatically in some cases it's a bug.

That’s it Job done!