Enterprise Managers "current activity":How in SQL?

Hi All !
Can someone show, how to obtain that, what Enterprise manager calls "current
activity", in SQL? I really would like to see the same output, not that,
what sp_who, sp_lock etc give.
I just have currently not the right knowledge to make all the neccessary
relationships from sp_who/sp_lock/sysprocesses etc
Any help would be great.
Thanks so far and
best regards,
Manfred BraunManfred Braun wrote:
> Hi All !
> Can someone show, how to obtain that, what Enterprise manager calls "current
> activity", in SQL? I really would like to see the same output, not that,
> what sp_who, sp_lock etc give.
> I just have currently not the right knowledge to make all the neccessary
> relationships from sp_who/sp_lock/sysprocesses etc
> Any help would be great.
> Thanks so far and
> best regards,
> Manfred Braun
>
Hi Manfred
You could try to run a trace while you open "Current activity". This
would most likely reveal which sql statement EM is running to view that
info.
Regards
Steen Schlüter Persson
Database Administrator / System Administrator|||Also, take a look at this procedure by Erland:
http://www.sommarskog.se/sqlutil/aba_lockinfo.html
HTH
Kalen Delaney, SQL Server MVP
"Steen Persson (DK)" <steen@.asavaengetREMOVETHIS.dk> wrote in message
news:OllyWgkjGHA.836@.TK2MSFTNGP02.phx.gbl...
> Manfred Braun wrote:
>> Hi All !
>> Can someone show, how to obtain that, what Enterprise manager calls
>> "current activity", in SQL? I really would like to see the same output,
>> not that, what sp_who, sp_lock etc give.
>> I just have currently not the right knowledge to make all the neccessary
>> relationships from sp_who/sp_lock/sysprocesses etc
>> Any help would be great.
>> Thanks so far and
>> best regards,
>> Manfred Braun
>>
> Hi Manfred
> You could try to run a trace while you open "Current activity". This would
> most likely reveal which sql statement EM is running to view that info.
>
> --
> Regards
> Steen Schlüter Persson
> Database Administrator / System Administrator