Hi!
Use "insert" command to insert result of SP into temporary table. Then you can query from temporary table.
>>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
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.