This should work:
select c.session_id, c.client_net_address from sys.dm_exec_sessions s
inner join sys.dm_exec_connections c on s.session_id=c.session_id
where s.program_name like '%profiler%'Of course the actual problem is;
We have about 10 or so users who have access to login to our database and run SQL Server Profiler.
The problem is that they're all using the same username/password to access the database,