Skip to content

Instantly share code, notes, and snippets.

@bartread

bartread/getalleventtypesrecorded.sql

Created January 10, 2017 14:00
Show Gist options
  • Save bartread/41c23c98d1823fb450219d2109ddfa5d to your computer and use it in GitHub Desktop.
Save bartread/41c23c98d1823fb450219d2109ddfa5d to your computer and use it in GitHub Desktop.
Download ZIP
Gets a list of all the distinct event types recorded in a SQL Profiler trace table.
Raw
getalleventtypesrecorded.sql
SELECT DISTINCT te.name
FROM [YOUR_TRACE_SCHEMA_NAME].[YOUR_TRACE_TABLE_NAME] AS d
INNER JOIN sys.trace_events AS te
ON te.trace_event_id = d.EventClass;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment