Accessing dbname in result set from sp_who.

[AWEinCA]

If I want to loop through a sp_who result set, how would I look at what database a user is logged into?

Syntax???

while sp_who
Begin
if (sp_who.dbname = 'testdb')
.
.
.
END [sig][/sig]

 

[TomSark]

NO, try using insert/exec and insert the results from sp_who into a temp table, then use a cursor to process the results...

Tom [sig][/sig]