Home Forums SQL Server 7,2000 Administration Finding out what servers are connected to what database... RE: Finding out what servers are connected to what database...

  • you can run "sp_who2" or "select * from sys.dm_exec_sessions" when connected to the server. This will show you the active connections. Column "hostname" shows the originating machinename.

    The rows with SPID < 51 are system processes.

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **