>Use sp_who and sp_who2 Stored Procedures, more help on BOL
Sp_Who works.
But to fully exploin the possibilities of sp_who i have to issue something like:
select * from (exec sp_who) where dbname='mydb'
Obviously it does not work.
How would you do that?
Thanks.
Kamil
A moment of silence is our cosmic reset button.