Trace Filter Ids

The companion lookup to the event class list - this one covers the data column ids you pass as the second parameter to sp_trace_setfilter. Every filterable column is here with its official description: TextData, host name, application name, login, SPID, duration, reads, writes, CPU, object name, database name, row counts and the rest.

ID	Name	Description
1	TextData	Text value dependent on the event class that is captured in the trace.
2	BinaryData	Binary value dependent on the event class captured in the trace.
3	DatabaseID	ID of the database specified by the USE database statement, or the default database if no USE database statement is issued for a given connection.
4	TransactionID	System-assigned ID of the transaction.
6	NTUserName	Microsoft Windows NT user name.
7	NTDomainName	Windows NT domain to which the user belongs.
8	ClientHostName	Name of the client computer that originated the request.
9	ClientProcessID	ID assigned by the client computer to the process in which the client application is running.
10	ApplicationName	Name of the client application that created the connection to an instance of SQL Server. This column is populated with the values passed by the application rather than the displayed name of the program.
11	SQLSecurityLoginName	SQL Server login name of the client.
12	SPID	Server Process ID assigned by SQL Server to the process associated with the client.
13	Duration	Amount of elapsed time (in milliseconds) taken by the event. This data column is not populated by the Hash Warning event.
14	StartTime	Time at which the event started, when available.
15	EndTime	Time at which the event ended. This column is not populated for starting event classes, such as SQL:BatchStarting or SP:Starting. It is also not populated by the Hash Warning event.
16	Reads	Number of logical disk reads performed by the server on behalf of the event. This column is not populated by the Lock:Released event.
17	Writes	Number of physical disk writes performed by the server on behalf of the event.
18	CPU	Amount of CPU time (in milliseconds) used by the event.
19	Permissions	Represents the bitmap of permissions; used by Security Auditing.
20	Severity	Severity level of an exception.
21	EventSubClass	Type of event subclass. This data column is not populated for all event classes.
22	ObjectID	System-assigned ID of the object.
23	Success	Success of the permissions usage attempt; used for auditing.
24	IndexID	ID for the index on the object affected by the event. To determine the index ID for an object, use the indid column of the sysindexes system table.
25	IntegerData	Integer value dependent on the event class captured in the trace.
26	ServerName	Name of the instance of SQL Server (either servername or servername\instancename) being traced.
27	EventClass	Type of event class being recorded.
28	ObjectType	Type of object (such as table, function, or stored procedure).
29	NestLevel	Nest Level
30	State	Server state, in case of an error.
31	Error	Error number.
32	Mode	Lock mode of the lock acquired. This column is not populated by the Lock:Released event.
33	Handle	Handle of the object referenced in the event.
34	ObjectName	Name of object accessed.
35	DatabaseName	Name of the database specified in the USE database statement.
36	Filename	Logical name of the file name modified.
37	ObjectOwner	Owner ID of the object referenced.
38	TargetRoleName	Name of the database or server-wide role targeted by a statement.
39	TargetUserName	User name of the target of some action.
40	DatabaseUserName	SQL Server database username of the client.
41	LoginSID	Security identification number (SID) of the logged-in user.
42	TargetLoginName	Login name of the target of some action.
43	TargetLoginSID	SID of the login that is the target of some action.
44	ColumnPermissionsSet	Column-level permissions status; used by Security Auditing.