Using Profiler in SQL2K

• Ross McMicken

  SSCarpal Tunnel

  Points: 4438

  More actions

  March 18, 2009 at 8:15 am

  #73470

  Is there any way at all for a non-sysadmin to use profiler? Due to a perceived security issue on sysadmin equivalents on development servers, I am going to lose my sysadmin rights. I use Profiler frequently to troubleshoot issues, and am trying to find a way to continue using it without having to get a DBA to do the trace.

• MarkusB

  SSC-Dedicated

  Points: 37370

  More actions

  March 18, 2009 at 9:07 am

  #961989

  In SQL2005 or later sysadmins and anyone whith ALTER TRACE permission can use profiler.

  In SQL2000 or earlier only sysadmins can run a trace in profiler.

  [font="Verdana"]Markus Bohse[/font]