SET NOCOUNT ON GO CREATE TABLE dbo.ColumnList ( ColumnID smallint NOT NULL, ColumnName varchar(50) NOT NULL, ColumnDescription varchar(300) NULL, DataType varchar(25) ) GO SET NOCOUNT ON INSERT INTO [ColumnList] ([ColumnID],[ColumnName],[ColumnDescription],[DataType])VALUES(1,'TextData','Text value dependent on the event class that is captured in the trace','nvarchar(128)') INSERT INTO [ColumnList] ([ColumnID],[ColumnName],[ColumnDescription],[DataType])VALUES(2,'BinaryData','Binary value dependent on the event class captured in the trace','varbinary') INSERT INTO [ColumnList] ([ColumnID],[ColumnName],[ColumnDescription],[DataType])VALUES(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. The value for a database can be determined by using the DB_ID function.','int') INSERT INTO [ColumnList] ([ColumnID],[ColumnName],[ColumnDescription],[DataType])VALUES(4,'TransactionID','System-assigned ID of the transaction','bigint') INSERT INTO [ColumnList] ([ColumnID],[ColumnName],[ColumnDescription],[DataType])VALUES(5,'Reserved',NULL,NULL) INSERT INTO [ColumnList] ([ColumnID],[ColumnName],[ColumnDescription],[DataType])VALUES(6,'NTUserName','Microsoft Windows NT; user name','nvarchar(128)') INSERT INTO [ColumnList] ([ColumnID],[ColumnName],[ColumnDescription],[DataType])VALUES(7,'NTDomainName','Windows NT domain to which the user belongs','nvarchar(128)') INSERT INTO [ColumnList] ([ColumnID],[ColumnName],[ColumnDescription],[DataType])VALUES(8,'ClientHostName','Name of the client computer that originated the request.','nvarchar(128)') INSERT INTO [ColumnList] ([ColumnID],[ColumnName],[ColumnDescription],[DataType])VALUES(9,'ClientProcessID','ID assigned by the client computer to the process in which the client application is running','int') INSERT INTO [ColumnList] ([ColumnID],[ColumnName],[ColumnDescription],[DataType])VALUES(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','nvarchar(128)') INSERT INTO [ColumnList] ([ColumnID],[ColumnName],[ColumnDescription],[DataType])VALUES(11,'SQLSecurityLoginName','SQL Server login name of the client','nvarchar(128)') INSERT INTO [ColumnList] ([ColumnID],[ColumnName],[ColumnDescription],[DataType])VALUES(12,'SPID','Server Process ID assigned by SQL Server to the process associated with the client','int') INSERT INTO [ColumnList] ([ColumnID],[ColumnName],[ColumnDescription],[DataType])VALUES(13,'Duration','Amount of elapsed time (in milliseconds) taken by the event. This data column is not populated by the Hash Warning event','bigint') INSERT INTO [ColumnList] ([ColumnID],[ColumnName],[ColumnDescription],[DataType])VALUES(14,'StartTime','Time at which the event started, when available','datetime') INSERT INTO [ColumnList] ([ColumnID],[ColumnName],[ColumnDescription],[DataType])VALUES(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','datetime') INSERT INTO [ColumnList] ([ColumnID],[ColumnName],[ColumnDescription],[DataType])VALUES(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','bigint') INSERT INTO [ColumnList] ([ColumnID],[ColumnName],[ColumnDescription],[DataType])VALUES(17,'Writes','Number of physical disk writes performed by the server on behalf of the event','bigint') INSERT INTO [ColumnList] ([ColumnID],[ColumnName],[ColumnDescription],[DataType])VALUES(18,'CPU','Amount of CPU time (in milliseconds) used by the event','int') INSERT INTO [ColumnList] ([ColumnID],[ColumnName],[ColumnDescription],[DataType])VALUES(19,'Permissions','Represents the bitmap of permissions; used by Security Auditing','int') INSERT INTO [ColumnList] ([ColumnID],[ColumnName],[ColumnDescription],[DataType])VALUES(20,'Severity','Severity level of an exception','int') INSERT INTO [ColumnList] ([ColumnID],[ColumnName],[ColumnDescription],[DataType])VALUES(21,'EventSubClass','Type of event subclass. This data column is not populated for all event classes','int') INSERT INTO [ColumnList] ([ColumnID],[ColumnName],[ColumnDescription],[DataType])VALUES(22,'ObjectID','System-assigned ID of the object','int') INSERT INTO [ColumnList] ([ColumnID],[ColumnName],[ColumnDescription],[DataType])VALUES(23,'Success','Success of the permissions usage attempt; used for auditing. 1 = success 0 = failure','int') INSERT INTO [ColumnList] ([ColumnID],[ColumnName],[ColumnDescription],[DataType])VALUES(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','int') INSERT INTO [ColumnList] ([ColumnID],[ColumnName],[ColumnDescription],[DataType])VALUES(25,'IntegerData','Integer value dependent on the event class captured in the trace','int') INSERT INTO [ColumnList] ([ColumnID],[ColumnName],[ColumnDescription],[DataType])VALUES(26,'ServerName','Name of the instance of SQL Server (either servername or servername\instancename) being traced','nvarchar(128)') INSERT INTO [ColumnList] ([ColumnID],[ColumnName],[ColumnDescription],[DataType])VALUES(27,'EventClass','Type of event class being recorded','int') INSERT INTO [ColumnList] ([ColumnID],[ColumnName],[ColumnDescription],[DataType])VALUES(28,'ObjectType','Type of object (such as table, function, or stored procedure)','int') INSERT INTO [ColumnList] ([ColumnID],[ColumnName],[ColumnDescription],[DataType])VALUES(29,'NestLevel','The nesting level at which this stored procedure is executing. See @@NESTLEVEL','int') INSERT INTO [ColumnList] ([ColumnID],[ColumnName],[ColumnDescription],[DataType])VALUES(30,'State','Server state, in case of an error','int') INSERT INTO [ColumnList] ([ColumnID],[ColumnName],[ColumnDescription],[DataType])VALUES(31,'Error','Error number','int') INSERT INTO [ColumnList] ([ColumnID],[ColumnName],[ColumnDescription],[DataType])VALUES(32,'Mode','Lock mode of the lock acquired. This column is not populated by the Lock:Released event','int') INSERT INTO [ColumnList] ([ColumnID],[ColumnName],[ColumnDescription],[DataType])VALUES(33,'Handle','Handle of the object referenced in the event','int') INSERT INTO [ColumnList] ([ColumnID],[ColumnName],[ColumnDescription],[DataType])VALUES(34,'ObjectName','Name of object accessed','nvarchar(128)') INSERT INTO [ColumnList] ([ColumnID],[ColumnName],[ColumnDescription],[DataType])VALUES(35,'DatabaseName','Name of the database specified in the USE database statement','nvarchar(128)') INSERT INTO [ColumnList] ([ColumnID],[ColumnName],[ColumnDescription],[DataType])VALUES(36,'Filename','Logical name of the file name modified','nvarchar(128)') INSERT INTO [ColumnList] ([ColumnID],[ColumnName],[ColumnDescription],[DataType])VALUES(37,'ObjectOwner','Owner ID of the object referenced','nvarchar(128)') INSERT INTO [ColumnList] ([ColumnID],[ColumnName],[ColumnDescription],[DataType])VALUES(38,'TargetRoleName','Name of the database or server-wide role targeted by a statement','nvarchar(128)') INSERT INTO [ColumnList] ([ColumnID],[ColumnName],[ColumnDescription],[DataType])VALUES(39,'TargetUserName','User name of the target of some action','nvarchar(128)') INSERT INTO [ColumnList] ([ColumnID],[ColumnName],[ColumnDescription],[DataType])VALUES(40,'DatabaseUserName','SQL Server database username of the client','nvarchar(128)') INSERT INTO [ColumnList] ([ColumnID],[ColumnName],[ColumnDescription],[DataType])VALUES(41,'LoginSID','Security identification number (SID) of the logged-in user','varbinary') INSERT INTO [ColumnList] ([ColumnID],[ColumnName],[ColumnDescription],[DataType])VALUES(42,'TargetLoginName','Login name of the target of some action','nvarchar(128)') INSERT INTO [ColumnList] ([ColumnID],[ColumnName],[ColumnDescription],[DataType])VALUES(43,'TargetLoginSID','SID of the login that is the target of some action','varbinary') INSERT INTO [ColumnList] ([ColumnID],[ColumnName],[ColumnDescription],[DataType])VALUES(44,'ColumnPermissionsSet','Column-level permissions status; used by Security Auditing','int') GO CREATE UNIQUE CLUSTERED INDEX [UCI_ColumnList_ColumnID] ON [dbo].[ColumnList]([ColumnID]) GO CREATE NONCLUSTERED INDEX [UCI_ColumnList_ColumnName] ON [dbo].[ColumnList]([ColumnName]) GO