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: 430

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

Related posts about Database Administration

Related posts about transact-sql