Friday, March 30, 2012

Profiler (GUI) uses SA account

HI,
When I start MS Sql server 7.0 / Profiler (GUI), it uses SA account.
Is it possible to start Profiler (GUI) with another account ?
thank you
dannyDanny,
In SQL 7.0 you can just grant exec permission on xp_trace*.* series
extended stor procs for a user account to run a trace using profiler.
--
Dinesh.
SQL Server FAQ at
http://www.tkdinesh.com
"Danny Presse" <dpresse@.congresmtl.com> wrote in message
news:eufEH0eXDHA.1680@.tk2msftngp13.phx.gbl...
> HI,
> When I start MS Sql server 7.0 / Profiler (GUI), it uses SA account.
> Is it possible to start Profiler (GUI) with another account ?
> thank you
> danny
>
>

No comments:

Post a Comment