How to run SQL Profiler without sysadmin rights

microsoft.public.sqlserver.server

19 Mar 2005 1:03 AM

pshroads

I thought I'd share what I do to enable people to run SQL Profiler
traces without having to give them sysadmin rights. I wrote a batch
file that calls Profiler from the command line as follows:

profiler /Sserver /Uuser /Ppassword /Tx

Then I bought a batch file compiler (do a google search and lots come
up, most around $30) and compiled the batchfile in to an executable.
Now I just distribute the executable.

Thought I'd share because I've been trying to find a way to let people
trace without sysadmin rights for a long time!