Prev: bcp/bulk insert of csv file that contains comma
Next: images in select query
From: Dan Guzman on 3 May 2010 20:42
> I tried querying the sys.sysprocesses view, but quickly realized that this
> view only tracks host names for processes that have been initiated by a
> domain account (and please feel free to correct me if my assumption is
> wrong). I would definitely like to find a better way of listing all
> machines
> that currently have SQL Server active connections.

sys.sysprocesses will include both trusted and standard SQL connections.
However, consider using sys.dm_exec_sessions since sysprocesses is
deprecated.

--
Hope this helps.

Dan Guzman
SQL Server MVP
http://weblogs.sqlteam.com/dang/



 | 
Pages: 1
Prev: bcp/bulk insert of csv file that contains comma
Next: images in select query