Home > Articles > Data

  • Print
  • + Share This
Like this article? We recommend

Profiler Trace Privileges

If you're using SQL Server version 7.0 or 2000 and you're not a member of the System Administrators built-in server role, you can't run a Profiler trace. Of course, if you're using SQL Server versions before 7.0 you should stop reading this article and upgrade immediately! <g> On a more serious note, version 2005 finally allows non-system administrators to run traces.

Frustrating as it is, an inability to run a trace isn't necessarily a curse; traces can place a huge burden on a server when created without necessary filters. However, SQL Profiler is an invaluable tool for troubleshooting your code, debugging your application, auditing your servers, and much more.

There are a couple of ways to work around this problem. One approach is to have a DBA create a Profiler trace and save its output as a table that developers can read. Another approach is to set up some development servers on which developers are members of the System Administrators built-in role, so that they can create and save their own traces.

  • + Share This
  • 🔖 Save To Your Account