Super raspuns Remus!
Stiam de sys.dm_exec_connections insa mie pe local imi da <local machine> si Books Online zice ca returneaza Host adress. Nu am putut verifica daca prin host adress se intelege host name sau host ip. Oricum am verificat si ai dreptate - returneaza ip-ul conexiunilor remote.
Cristian Andrei Lefter, SQL Server MVP
MCT, MCSA, MCDBA, MCAD, MCSD .NET,
MCTS, MCITP - Database Administrator SQL Server 2005
http://sqlserver.ro