Resolving SQL connections

[Mrtoddk]

Does anyone know of an app that will create a list of active SQL connections and display the host name of the computer that made the connection and the database they are using?

I can easily get a list of MAC a addresses and Database names by querying the sysprocesses table.

From a command prompt on the server, I can get a list of IP Address to MAC addresses (arp -a) for all connections on the server.

I can then use ping -a xxx.xxx.xxx.xxx to resolve the IP Address to Host name.

Is there something out there that will do all of this? I hate to reinvent the wheel.

Thanks in advance.

 

[SonOfEmidec1100]

Have a look at the system stored proc [blue]sp_who2[/blue]

Maybe this will help