SQL profiler

13 Jan 2006 9:26 AM

SimonZ

I would like to see what's happening on the database which I'm database
owner.

But when I open SQL profiler it requires that I'm a member of sys admin
server role.

What now?

I'm dbo of that database(I created it) but I can't see what's happening
there.

Is there some way to avoid this sys admin?

Or is there some other tool to show me the same as SQL profiler?

Thanks,S

13 Jan 2006 9:33 AM

Ryan

There is no workaround as such.

1 of the SQL MVPs released this recently. www.gajsoftware.com it was in Beta
when i looked but should do what you're after.

--
HTH. Ryan

Show quote

"SimonZ" <simon.zu***@studio-moderna.com> wrote in message
news:e7582NCGGHA.3936@TK2MSFTNGP12.phx.gbl...
>I would like to see what's happening on the database which I'm database
>owner.
>
> But when I open SQL profiler it requires that I'm a member of sys admin
> server role.
>
> What now?
>
> I'm dbo of that database(I created it) but I can't see what's happening
> there.
>
> Is there some way to avoid this sys admin?
>
> Or is there some other tool to show me the same as SQL profiler?
>
> Thanks,S
>
>

13 Jan 2006 11:42 AM

ML

Using sp_trace_create (look it up in Books Online) your sysadmin can create a
trace that can be accessed through the fn_trace_getinfo system function by
other users (e.g. users who are not members of the sysadmin fixed system
role).

ML

---
http://milambda.blogspot.com/