Thank you HomeBrew01.

I have been needing something like that for awhile but haven't had the time to put it together. 

After the previous post, I actually looked at the code and found the obvious error in the last usage line.  I also thought about the value of returning a varchar...

This may need to be adjusted to your situation, but I have used the following function for a while. 

One note, it accepts a character string and returns a character...

I don't know the current price of a CAL but you might be better off just buying the per-processor license and avoid having to worry about the number of users...

>>>

Openrowset('SQLOLEDB','Server=SERVERNAME;UID=xx;PWD=nn;Database=dd','exec sp_who')

<<<

That did it.  Thanks.

>>>>

Select * into #T1

from Openrowset('SQLOLEDB','Trusted_connection=yes;Data Source=YOURSERVER','exec sp_who') dt

select * from #T1

drop table #T1

<<<<<

Noeld, I must be missing something with this code.  When I run the query it executes sp_who on...

Remi,

One attribute of Openrowset requires the connection to return columns.  This may be the problem when executing sp_who or sp_who2 depending on the provider used.

Raj,

The code was an example...

I thank you for confirming the event.  I thought I was just experiencing premature 'old timers' disease and losing my way around the form.  This is an inconsistent, irritating, recurring...

THANK YOU SUSHILA!!!

>>Rats - I just spent the last half an hour typing out the various steps - only to have the whole text "vanish" - ctrl z isn't...

UPDATE:  My previous post included some stray code from an experiment.  There is no need for the lines

                       DECLARE @Field as varchar(15)

                       set @Field = 'DBName' 

The code snippet below is what I use to sort the results of sp_who2. This is  what Chris suggested.  It is specific to sp_who2.

If you need to work with the results...

The logins are recorded in the error log.  As far as I know, the login event is not stored in a table.

I use the following query to filter log data.  You...

Glad to see the problem resolved.

Steve,

Your last post raises a question and potential problem.  Are you storing the result of (Col3 + Col5) / 2  in column 4?  As you point out, this may well...