check your SQL Server online books for a command prompt utility call ISQL. You can run SP_WHO store procedure from the command line.

Quote:

isql -E -w 1024 -Q sp_who >sp_who.txt



Edited by Howard Bullock (2006-01-13 07:50 PM)
_________________________
Home page: http://www.kixhelp.com/hb/