Check other open connections

[Joe Smith IX]

Hi there, In SQL Server, is there anyway to check other open connections (who else currently connected to the database)? Thanks.

[Mike Dimmick]

sp_who reports all current connections. The procedure takes its data from the sysprocesses view (SQL Server 2000) or the sys.dm_exec_connections dynamic management view in SQL Server 2005.

Stability. What an interesting concept. -- Chris Maunder