Get details about an sql trace

Question

Is there any way to figure out the host machine name from where an sql trace was originated or some other details like spid against which the trace is running ?

When I execute the following query -

SELECT *  
FROM :: fn_trace_getinfo(default)  
where property = 5 and value = 1

I get there are two sql traces running ,for the first one I am sure is the default one initiated by the sql server but not sure about the other one.

I am also not able to get any idea when I query the following -

select * 
from sys.sysprocesses  
where program_name like '%profiler%'

Regards, Hemant

Answer 1

0

I adopted the following query from @Håkan Winther great script to find "who changed what"

SELECT * 
FROM    
[fn_trace_gettable](CONVERT(VARCHAR(150), ( SELECT TOP 1
value
FROM    [fn_trace_getinfo](NULL)
WHERE   [property] = 2
)), DEFAULT) T

Credit to @Håkan Winther!

answered Feb 16 '11 at 10:54 PM

Cyborg
10.1k ● 29 ● 39 ● 44

This query will not return any details about those traces where file name property is not available.Even if this file name property is available for a trace how would I retrieve the session id against which this particular trace process is running or say host name from where the trace was originated ?

Thanks, Hemant

Feb 17 '11 at 02:03 AM Hemant

(comments are locked)

Get details about an sql trace

Follow this question

Related Questions