How to 'exec sp_who' into #temp_table ?

How to 'exec sp_who' into #temp_table ?
Thanks !
"SOHO" <hkwin2000@.hotmail.com> wrote in message
news:#RKHZjQcFHA.2128@.TK2MSFTNGP15.phx.gbl...
> How to 'exec sp_who' into #temp_table ?
>
> --
> Thanks !
>
>
CREATE TABLE #temp_table (
col1..
..
coln)
INSERT #temp_table
exec sp_who
Note the temp table's columns need to match the result set from the sp_who
sproc. Also, you might like sp_who2 better. It gives more information.
Rick Sawtell
MCT, MCSD, MCDBA
|||See if this helps:
http://support.microsoft.com/newsgro...-us&sloc=en-us
AMB
"SOHO" wrote:

> How to 'exec sp_who' into #temp_table ?
>
> --
> Thanks !
>
>
|||Thanks to all of you!!
Problems been solved.
Thanks !
"SOHO" <hkwin2000@.hotmail.com> glsD:%23RKHZjQcFHA.2128@.TK2MSFTNGP15.phx .gbl...
> How to 'exec sp_who' into #temp_table ?
>
> --
> Thanks !
>
>