Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Sp_who order by dbname
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00777802
Message ID:
00777847
Views:
12
Write your own. You can get the source for sp_who using this:

use master
execute sp_helptext 'sp_who'

-Mike

>Hi,
>
>By default, sp_who order result by spid. It can be filtered by active process or by user, but it can't be filtered or ordered by dbname (or loginname or hostname).
>
>Does anybody have a solution ?
>
>Thanks
Michael Levy
MCSD, MCDBA
ma_levy@hotmail.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform