Learn Who Started that Trace with the Default Trace
Posted
by Jonathan Kehayias
on SQL Blog
See other posts from SQL Blog
or by Jonathan Kehayias
Published on Wed, 29 Dec 2010 19:00:00 GMT
Indexed on
2010/12/29
21:59 UTC
Read the original article
Hit count: 469
Filed under:
Database Administration
|transact-sql
This is not Extended Event related but it came from a question on Twitter about how to tell who and from what machine a server side trace was created, and there is no way to explain this in 140 characters so here’s a blog post. This information is tracked in the Default Trace and can be found by querying for EventClass 175 which is the Audit Server Alter Trace Event trace_event_id from sys.trace_events. select trace_event_id , name from sys . trace_events where name like '%trace%' To query...(read more)
© SQL Blog or respective owner
