Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Help on Stored Procedure results

Author  Topic 

Ask SQLTeam Question

0 Posts

Posted - 2005-10-27 : 07:57:31
Manvinder Singh writes "I want to store informaion returned by System stored procedure into a temporary table.
I want to filter information returned by sp_who2.

How can I do it using T-SQL.

Please provide help on this."

Master Smack Fu Yak Hacker

1907 Posts

Posted - 2005-10-27 : 09:20:02
you create the table which matches the sp_who2 ouput..
and then run the

Insert <Table_Name>
Exec Sp_who2

Complicated things can be done by simple thinking
Go to Top of Page

- Advertisement -