Is it possible to see who is running SQL Server Profiler against a certain database and possibly from what machine? Say through Profiler itself or by T-SQL statement.
I wonder if it is even possible to find out Active Directly user name under which the profiler is running.
[UPDATE] As a reference, here is a way to retrieve only SQL Server Profile processes
declare @sp_who2 table ( SPID int, status varchar(50), login varchar(100), HostName varchar(100), BlkBy varchar(100), DBName varchar(100), Command varchar(100), CPUTime int, DiskIO int, LastBatch varchar(50), ProgramName varchar(150), SPID2 int, REQUESTID int ) insert @sp_who2 exec sp_who2 select * from @sp_who2 where ProgramName like 'SQL Server Profiler - %'