--SQL SERVER – 2005 – List Tables in Database Without Primary Key

--SQL SERVER – 2005 – List Tables in Database Without Primary Key
SELECT SCHEMA_NAME(schema_id) AS SchemaName,name AS TableName
FROM sys.tables
WHERE OBJECTPROPERTY(OBJECT_ID,'TableHasPrimaryKey') = 0
ORDER BY SchemaName, TableName;
GO


--SQL SERVER – 2005 – Find Tables With Primary Key Constraint in Database
SELECT i.name AS IndexName,
OBJECT_NAME(ic.OBJECT_ID) AS TableName,
COL_NAME(ic.OBJECT_ID,ic.column_id) AS ColumnName
FROM sys.indexes AS i
INNER JOIN sys.index_columns AS ic
ON i.OBJECT_ID = ic.OBJECT_ID
AND i.index_id = ic.index_id
WHERE i.is_primary_key = 1


--SQL SERVER – 2005 – Find Tables With Foreign Key Constraint in Database
SELECT f.name AS ForeignKey,
OBJECT_NAME(f.parent_object_id) AS TableName,
COL_NAME(fc.parent_object_id,
fc.parent_column_id) AS ColumnName,
OBJECT_NAME (f.referenced_object_id) AS ReferenceTableName,
COL_NAME(fc.referenced_object_id,
fc.referenced_column_id) AS ReferenceColumnName
FROM sys.foreign_keys AS f
INNER JOIN sys.foreign_key_columns AS fc
ON f.OBJECT_ID = fc.constraint_object_id

Table ,Index and File group

select case when indexes.type_desc in ('HEAP','CLUSTERED')
then 'Table-' + indexes.type_desc
else ' NC Index' end as indexType,
rtrim(cast(
case when indexProperty(objects.object_id,indexes.name,'IsUnique') = 1
then 'unique ' else '' end +
case when isNull(objectProperty(object_id(schemas.name + '.'
+ indexes.name),'IsConstraint'),0) = 1
then 'constraint ' else '' end +
case when indexProperty(objects.object_id,indexes.name,'IsAutoStatistics') = 1
then 'auto ' else '' end +
case when indexProperty(objects.object_id,indexes.name,'IsStatistics') = 1
then 'statistics ' else '' end +
case when indexProperty(objects.object_id,indexes.name,'IsHypothetical') = 1
then 'hypothetical ' else '' end
as varchar(30))) as indexProperties,
schemas.name + '.' + objects.name as tableName,
coalesce(indexes.name,'') as indexName,
filegroups.name as filegroup
from sys.indexes as indexes
join sys.objects
on indexes.object_id = objects.object_id
join sys.schemas
on objects.schema_id = schemas.schema_id
join sys.filegroups as filegroups
on indexes.data_space_id = filegroups.data_space_id
where objectproperty(indexes.object_id,'IsMSShipped') = 0
order by indextype,tableName, case when indexes.type_desc in ('HEAP','CLUSTERED') then 0 else 1 end

Trace Table SQL Server 2005

A. Using fn_trace_gettable to import rows from a trace file
The following example calls fn_trace_gettable inside the FROM clause of a SELECT...INTO statement.

USE AdventureWorks;
GO
SELECT * INTO temp_trc
FROM fn_trace_gettable('c:\temp\my_trace.trc', default);
GO


B. Using fn_trace_gettable to return a table with an IDENTITY column that can be loaded into a SQL Server table
The following example calls the function as part of a SELECT...INTO statement and returns a table with an IDENTITY column that can be loaded into the table temp_trc.


USE AdventureWorks;
GO
SELECT IDENTITY(int, 1, 1) AS RowNumber, * INTO temp_trc
FROM fn_trace_gettable('c:\temp\my_trace.trc', default);
GO



GO
/****** Object: Table [dbo].[Trace_Table2005] Script Date: 04/13/2010 10:36:52 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Trace_Table2005](
[RowNumber] [int] IDENTITY(0,1) NOT NULL,
[EventClass] [int] NULL,
[TextData] [ntext] NULL,
[ApplicationName] [nvarchar](128) NULL,
[NTUserName] [nvarchar](128) NULL,
[LoginName] [nvarchar](128) NULL,
[CPU] [int] NULL,
[Reads] [bigint] NULL,
[Writes] [bigint] NULL,
[Duration] [bigint] NULL,
[ClientProcessID] [int] NULL,
[SPID] [int] NULL,
[StartTime] [datetime] NULL,
[EndTime] [datetime] NULL,
[BinaryData] [image] NULL,
[ColumnPermissions] [int] NULL,
[DBUserName] [nvarchar](128) NULL,
[DatabaseID] [int] NULL,
[DatabaseName] [nvarchar](128) NULL,
[EventSequence] [bigint] NULL,
[EventSubClass] [int] NULL,
[HostName] [nvarchar](128) NULL,
[IsSystem] [int] NULL,
[LoginSid] [image] NULL,
[NTDomainName] [nvarchar](128) NULL,
[NestLevel] [int] NULL,
[ObjectType] [int] NULL,
[OwnerName] [nvarchar](128) NULL,
[RequestID] [int] NULL,
[RoleName] [nvarchar](128) NULL,
[ServerName] [nvarchar](128) NULL,
[SessionLoginName] [nvarchar](128) NULL,
[Success] [int] NULL,
[TargetLoginName] [nvarchar](128) NULL,
[TargetLoginSid] [image] NULL,
[TargetUserName] [nvarchar](128) NULL,
[TransactionID] [bigint] NULL,
[XactSequence] [bigint] NULL,
[BigintData1] [bigint] NULL,
[FileName] [nvarchar](128) NULL,
[GUID] [uniqueidentifier] NULL,
[IndexID] [int] NULL,
[IntegerData] [int] NULL,
[MethodName] [nvarchar](128) NULL,
[ObjectID] [int] NULL,
[ProviderName] [nvarchar](128) NULL,
[BigintData2] [bigint] NULL,
[Error] [int] NULL,
[IntegerData2] [int] NULL,
[Severity] [int] NULL,
[State] [int] NULL,
[ObjectName] [nvarchar](128) NULL,
[Type] [int] NULL,
[Offset] [int] NULL,
[PlanHandle] [image] NULL,
[SqlHandle] [image] NULL,
[LineNumber] [int] NULL,
[LinkedServerName] [nvarchar](128) NULL,
[ParentName] [nvarchar](128) NULL,
[Permissions] [bigint] NULL,
[RowCounts] [bigint] NULL,
[SourceDatabaseID] [int] NULL,
[ObjectID2] [bigint] NULL,
[Mode] [int] NULL,
[OwnerID] [int] NULL,
[Handle] [int] NULL,
PRIMARY KEY CLUSTERED
(
[RowNumber] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

TimeTable schools_2006 _server_side_trace_file

SQL Server 2005 generates trace events in various event categories

http://publib.boulder.ibm.com/infocenter/tivihelp/v2r1/index.jsp?topic=/com.ibm.itcim.doc/tcim85_install407.html


/****************************************************/
/* Created by: SQL Server Profiler 2005 */
/* Date: 04/12/2010 02:09:55 PM */
/****************************************************/


-- Create a Queue
declare @rc int
declare @TraceID int
declare @maxfilesize bigint
set @maxfilesize = 5

-- Please replace the text InsertFileNameHere, with an appropriate
-- filename prefixed by a path, e.g., c:\MyFolder\MyTrace. The .trc extension
-- will be appended to the filename automatically. If you are writing from
-- remote server to local drive, please use UNC path and make sure server has
-- write access to your network share

exec @rc = sp_trace_create @TraceID output, 2, N'd:\temp\timetableUWS_schools2006', @maxfilesize, NULL
if (@rc != 0) goto error

-- Client side File and Table cannot be scripted

-- Set the events
declare @on bit
set @on = 1
exec sp_trace_setevent @TraceID, 14, 1, @on
exec sp_trace_setevent @TraceID, 14, 9, @on
exec sp_trace_setevent @TraceID, 14, 6, @on
exec sp_trace_setevent @TraceID, 14, 10, @on
exec sp_trace_setevent @TraceID, 14, 14, @on
exec sp_trace_setevent @TraceID, 14, 11, @on
exec sp_trace_setevent @TraceID, 14, 12, @on
exec sp_trace_setevent @TraceID, 15, 15, @on
exec sp_trace_setevent @TraceID, 15, 16, @on
exec sp_trace_setevent @TraceID, 15, 9, @on
exec sp_trace_setevent @TraceID, 15, 13, @on
exec sp_trace_setevent @TraceID, 15, 17, @on
exec sp_trace_setevent @TraceID, 15, 6, @on
exec sp_trace_setevent @TraceID, 15, 10, @on
exec sp_trace_setevent @TraceID, 15, 14, @on
exec sp_trace_setevent @TraceID, 15, 18, @on
exec sp_trace_setevent @TraceID, 15, 11, @on
exec sp_trace_setevent @TraceID, 15, 12, @on
exec sp_trace_setevent @TraceID, 17, 12, @on
exec sp_trace_setevent @TraceID, 17, 1, @on
exec sp_trace_setevent @TraceID, 17, 9, @on
exec sp_trace_setevent @TraceID, 17, 6, @on
exec sp_trace_setevent @TraceID, 17, 10, @on
exec sp_trace_setevent @TraceID, 17, 14, @on
exec sp_trace_setevent @TraceID, 17, 11, @on
exec sp_trace_setevent @TraceID, 39, 12, @on
exec sp_trace_setevent @TraceID, 39, 64, @on
exec sp_trace_setevent @TraceID, 100, 7, @on
exec sp_trace_setevent @TraceID, 100, 8, @on
exec sp_trace_setevent @TraceID, 100, 64, @on
exec sp_trace_setevent @TraceID, 100, 1, @on
exec sp_trace_setevent @TraceID, 100, 9, @on
exec sp_trace_setevent @TraceID, 100, 41, @on
exec sp_trace_setevent @TraceID, 100, 49, @on
exec sp_trace_setevent @TraceID, 100, 6, @on
exec sp_trace_setevent @TraceID, 100, 10, @on
exec sp_trace_setevent @TraceID, 100, 14, @on
exec sp_trace_setevent @TraceID, 100, 26, @on
exec sp_trace_setevent @TraceID, 100, 34, @on
exec sp_trace_setevent @TraceID, 100, 50, @on
exec sp_trace_setevent @TraceID, 100, 3, @on
exec sp_trace_setevent @TraceID, 100, 11, @on
exec sp_trace_setevent @TraceID, 100, 35, @on
exec sp_trace_setevent @TraceID, 100, 51, @on
exec sp_trace_setevent @TraceID, 100, 4, @on
exec sp_trace_setevent @TraceID, 100, 12, @on
exec sp_trace_setevent @TraceID, 100, 60, @on
exec sp_trace_setevent @TraceID, 10, 15, @on
exec sp_trace_setevent @TraceID, 10, 16, @on
exec sp_trace_setevent @TraceID, 10, 9, @on
exec sp_trace_setevent @TraceID, 10, 17, @on
exec sp_trace_setevent @TraceID, 10, 2, @on
exec sp_trace_setevent @TraceID, 10, 10, @on
exec sp_trace_setevent @TraceID, 10, 18, @on
exec sp_trace_setevent @TraceID, 10, 11, @on
exec sp_trace_setevent @TraceID, 10, 12, @on
exec sp_trace_setevent @TraceID, 10, 13, @on
exec sp_trace_setevent @TraceID, 10, 6, @on
exec sp_trace_setevent @TraceID, 10, 14, @on
exec sp_trace_setevent @TraceID, 11, 7, @on
exec sp_trace_setevent @TraceID, 11, 8, @on
exec sp_trace_setevent @TraceID, 11, 64, @on
exec sp_trace_setevent @TraceID, 11, 1, @on
exec sp_trace_setevent @TraceID, 11, 9, @on
exec sp_trace_setevent @TraceID, 11, 41, @on
exec sp_trace_setevent @TraceID, 11, 49, @on
exec sp_trace_setevent @TraceID, 11, 2, @on
exec sp_trace_setevent @TraceID, 11, 6, @on
exec sp_trace_setevent @TraceID, 11, 10, @on
exec sp_trace_setevent @TraceID, 11, 14, @on
exec sp_trace_setevent @TraceID, 11, 26, @on
exec sp_trace_setevent @TraceID, 11, 34, @on
exec sp_trace_setevent @TraceID, 11, 50, @on
exec sp_trace_setevent @TraceID, 11, 3, @on
exec sp_trace_setevent @TraceID, 11, 11, @on
exec sp_trace_setevent @TraceID, 11, 35, @on
exec sp_trace_setevent @TraceID, 11, 51, @on
exec sp_trace_setevent @TraceID, 11, 4, @on
exec sp_trace_setevent @TraceID, 11, 12, @on
exec sp_trace_setevent @TraceID, 11, 60, @on
exec sp_trace_setevent @TraceID, 38, 7, @on
exec sp_trace_setevent @TraceID, 38, 8, @on
exec sp_trace_setevent @TraceID, 38, 64, @on
exec sp_trace_setevent @TraceID, 38, 1, @on
exec sp_trace_setevent @TraceID, 38, 9, @on
exec sp_trace_setevent @TraceID, 38, 21, @on
exec sp_trace_setevent @TraceID, 38, 41, @on
exec sp_trace_setevent @TraceID, 38, 49, @on
exec sp_trace_setevent @TraceID, 38, 6, @on
exec sp_trace_setevent @TraceID, 38, 10, @on
exec sp_trace_setevent @TraceID, 38, 14, @on
exec sp_trace_setevent @TraceID, 38, 22, @on
exec sp_trace_setevent @TraceID, 38, 26, @on
exec sp_trace_setevent @TraceID, 38, 34, @on
exec sp_trace_setevent @TraceID, 38, 50, @on
exec sp_trace_setevent @TraceID, 38, 3, @on
exec sp_trace_setevent @TraceID, 38, 11, @on
exec sp_trace_setevent @TraceID, 38, 35, @on
exec sp_trace_setevent @TraceID, 38, 51, @on
exec sp_trace_setevent @TraceID, 38, 4, @on
exec sp_trace_setevent @TraceID, 38, 12, @on
exec sp_trace_setevent @TraceID, 38, 28, @on
exec sp_trace_setevent @TraceID, 38, 60, @on
exec sp_trace_setevent @TraceID, 35, 7, @on
exec sp_trace_setevent @TraceID, 35, 8, @on
exec sp_trace_setevent @TraceID, 35, 64, @on
exec sp_trace_setevent @TraceID, 35, 1, @on
exec sp_trace_setevent @TraceID, 35, 9, @on
exec sp_trace_setevent @TraceID, 35, 41, @on
exec sp_trace_setevent @TraceID, 35, 49, @on
exec sp_trace_setevent @TraceID, 35, 6, @on
exec sp_trace_setevent @TraceID, 35, 10, @on
exec sp_trace_setevent @TraceID, 35, 14, @on
exec sp_trace_setevent @TraceID, 35, 22, @on
exec sp_trace_setevent @TraceID, 35, 26, @on
exec sp_trace_setevent @TraceID, 35, 50, @on
exec sp_trace_setevent @TraceID, 35, 3, @on
exec sp_trace_setevent @TraceID, 35, 11, @on
exec sp_trace_setevent @TraceID, 35, 35, @on
exec sp_trace_setevent @TraceID, 35, 51, @on
exec sp_trace_setevent @TraceID, 35, 4, @on
exec sp_trace_setevent @TraceID, 35, 12, @on
exec sp_trace_setevent @TraceID, 35, 28, @on
exec sp_trace_setevent @TraceID, 35, 60, @on
exec sp_trace_setevent @TraceID, 34, 7, @on
exec sp_trace_setevent @TraceID, 34, 8, @on
exec sp_trace_setevent @TraceID, 34, 64, @on
exec sp_trace_setevent @TraceID, 34, 1, @on
exec sp_trace_setevent @TraceID, 34, 9, @on
exec sp_trace_setevent @TraceID, 34, 41, @on
exec sp_trace_setevent @TraceID, 34, 49, @on
exec sp_trace_setevent @TraceID, 34, 6, @on
exec sp_trace_setevent @TraceID, 34, 10, @on
exec sp_trace_setevent @TraceID, 34, 14, @on
exec sp_trace_setevent @TraceID, 34, 22, @on
exec sp_trace_setevent @TraceID, 34, 26, @on
exec sp_trace_setevent @TraceID, 34, 34, @on
exec sp_trace_setevent @TraceID, 34, 50, @on
exec sp_trace_setevent @TraceID, 34, 3, @on
exec sp_trace_setevent @TraceID, 34, 11, @on
exec sp_trace_setevent @TraceID, 34, 51, @on
exec sp_trace_setevent @TraceID, 34, 4, @on
exec sp_trace_setevent @TraceID, 34, 12, @on
exec sp_trace_setevent @TraceID, 34, 28, @on
exec sp_trace_setevent @TraceID, 34, 60, @on
exec sp_trace_setevent @TraceID, 36, 7, @on
exec sp_trace_setevent @TraceID, 36, 8, @on
exec sp_trace_setevent @TraceID, 36, 64, @on
exec sp_trace_setevent @TraceID, 36, 1, @on
exec sp_trace_setevent @TraceID, 36, 9, @on
exec sp_trace_setevent @TraceID, 36, 21, @on
exec sp_trace_setevent @TraceID, 36, 41, @on
exec sp_trace_setevent @TraceID, 36, 49, @on
exec sp_trace_setevent @TraceID, 36, 6, @on
exec sp_trace_setevent @TraceID, 36, 10, @on
exec sp_trace_setevent @TraceID, 36, 14, @on
exec sp_trace_setevent @TraceID, 36, 22, @on
exec sp_trace_setevent @TraceID, 36, 26, @on
exec sp_trace_setevent @TraceID, 36, 50, @on
exec sp_trace_setevent @TraceID, 36, 3, @on
exec sp_trace_setevent @TraceID, 36, 11, @on
exec sp_trace_setevent @TraceID, 36, 35, @on
exec sp_trace_setevent @TraceID, 36, 51, @on
exec sp_trace_setevent @TraceID, 36, 4, @on
exec sp_trace_setevent @TraceID, 36, 12, @on
exec sp_trace_setevent @TraceID, 36, 28, @on
exec sp_trace_setevent @TraceID, 36, 60, @on
exec sp_trace_setevent @TraceID, 43, 7, @on
exec sp_trace_setevent @TraceID, 43, 15, @on
exec sp_trace_setevent @TraceID, 43, 8, @on
exec sp_trace_setevent @TraceID, 43, 48, @on
exec sp_trace_setevent @TraceID, 43, 64, @on
exec sp_trace_setevent @TraceID, 43, 1, @on
exec sp_trace_setevent @TraceID, 43, 9, @on
exec sp_trace_setevent @TraceID, 43, 41, @on
exec sp_trace_setevent @TraceID, 43, 49, @on
exec sp_trace_setevent @TraceID, 43, 2, @on
exec sp_trace_setevent @TraceID, 43, 10, @on
exec sp_trace_setevent @TraceID, 43, 26, @on
exec sp_trace_setevent @TraceID, 43, 34, @on
exec sp_trace_setevent @TraceID, 43, 50, @on
exec sp_trace_setevent @TraceID, 43, 3, @on
exec sp_trace_setevent @TraceID, 43, 11, @on
exec sp_trace_setevent @TraceID, 43, 35, @on
exec sp_trace_setevent @TraceID, 43, 51, @on
exec sp_trace_setevent @TraceID, 43, 4, @on
exec sp_trace_setevent @TraceID, 43, 12, @on
exec sp_trace_setevent @TraceID, 43, 28, @on
exec sp_trace_setevent @TraceID, 43, 60, @on
exec sp_trace_setevent @TraceID, 43, 5, @on
exec sp_trace_setevent @TraceID, 43, 13, @on
exec sp_trace_setevent @TraceID, 43, 29, @on
exec sp_trace_setevent @TraceID, 43, 6, @on
exec sp_trace_setevent @TraceID, 43, 14, @on
exec sp_trace_setevent @TraceID, 43, 22, @on
exec sp_trace_setevent @TraceID, 43, 62, @on
exec sp_trace_setevent @TraceID, 37, 7, @on
exec sp_trace_setevent @TraceID, 37, 55, @on
exec sp_trace_setevent @TraceID, 37, 63, @on
exec sp_trace_setevent @TraceID, 37, 8, @on
exec sp_trace_setevent @TraceID, 37, 64, @on
exec sp_trace_setevent @TraceID, 37, 1, @on
exec sp_trace_setevent @TraceID, 37, 9, @on
exec sp_trace_setevent @TraceID, 37, 41, @on
exec sp_trace_setevent @TraceID, 37, 49, @on
exec sp_trace_setevent @TraceID, 37, 10, @on
exec sp_trace_setevent @TraceID, 37, 26, @on
exec sp_trace_setevent @TraceID, 37, 34, @on
exec sp_trace_setevent @TraceID, 37, 50, @on
exec sp_trace_setevent @TraceID, 37, 3, @on
exec sp_trace_setevent @TraceID, 37, 11, @on
exec sp_trace_setevent @TraceID, 37, 35, @on
exec sp_trace_setevent @TraceID, 37, 51, @on
exec sp_trace_setevent @TraceID, 37, 4, @on
exec sp_trace_setevent @TraceID, 37, 12, @on
exec sp_trace_setevent @TraceID, 37, 28, @on
exec sp_trace_setevent @TraceID, 37, 60, @on
exec sp_trace_setevent @TraceID, 37, 5, @on
exec sp_trace_setevent @TraceID, 37, 21, @on
exec sp_trace_setevent @TraceID, 37, 29, @on
exec sp_trace_setevent @TraceID, 37, 61, @on
exec sp_trace_setevent @TraceID, 37, 6, @on
exec sp_trace_setevent @TraceID, 37, 14, @on
exec sp_trace_setevent @TraceID, 37, 22, @on
exec sp_trace_setevent @TraceID, 42, 7, @on
exec sp_trace_setevent @TraceID, 42, 8, @on
exec sp_trace_setevent @TraceID, 42, 64, @on
exec sp_trace_setevent @TraceID, 42, 1, @on
exec sp_trace_setevent @TraceID, 42, 9, @on
exec sp_trace_setevent @TraceID, 42, 41, @on
exec sp_trace_setevent @TraceID, 42, 49, @on
exec sp_trace_setevent @TraceID, 42, 2, @on
exec sp_trace_setevent @TraceID, 42, 6, @on
exec sp_trace_setevent @TraceID, 42, 10, @on
exec sp_trace_setevent @TraceID, 42, 14, @on
exec sp_trace_setevent @TraceID, 42, 22, @on
exec sp_trace_setevent @TraceID, 42, 26, @on
exec sp_trace_setevent @TraceID, 42, 34, @on
exec sp_trace_setevent @TraceID, 42, 50, @on
exec sp_trace_setevent @TraceID, 42, 62, @on
exec sp_trace_setevent @TraceID, 42, 3, @on
exec sp_trace_setevent @TraceID, 42, 11, @on
exec sp_trace_setevent @TraceID, 42, 35, @on
exec sp_trace_setevent @TraceID, 42, 51, @on
exec sp_trace_setevent @TraceID, 42, 4, @on
exec sp_trace_setevent @TraceID, 42, 12, @on
exec sp_trace_setevent @TraceID, 42, 28, @on
exec sp_trace_setevent @TraceID, 42, 60, @on
exec sp_trace_setevent @TraceID, 42, 5, @on
exec sp_trace_setevent @TraceID, 42, 29, @on
exec sp_trace_setevent @TraceID, 45, 7, @on
exec sp_trace_setevent @TraceID, 45, 55, @on
exec sp_trace_setevent @TraceID, 45, 8, @on
exec sp_trace_setevent @TraceID, 45, 16, @on
exec sp_trace_setevent @TraceID, 45, 48, @on
exec sp_trace_setevent @TraceID, 45, 64, @on
exec sp_trace_setevent @TraceID, 45, 1, @on
exec sp_trace_setevent @TraceID, 45, 9, @on
exec sp_trace_setevent @TraceID, 45, 17, @on
exec sp_trace_setevent @TraceID, 45, 25, @on
exec sp_trace_setevent @TraceID, 45, 41, @on
exec sp_trace_setevent @TraceID, 45, 49, @on
exec sp_trace_setevent @TraceID, 45, 10, @on
exec sp_trace_setevent @TraceID, 45, 18, @on
exec sp_trace_setevent @TraceID, 45, 26, @on
exec sp_trace_setevent @TraceID, 45, 34, @on
exec sp_trace_setevent @TraceID, 45, 50, @on
exec sp_trace_setevent @TraceID, 45, 3, @on
exec sp_trace_setevent @TraceID, 45, 11, @on
exec sp_trace_setevent @TraceID, 45, 35, @on
exec sp_trace_setevent @TraceID, 45, 51, @on
exec sp_trace_setevent @TraceID, 45, 4, @on
exec sp_trace_setevent @TraceID, 45, 12, @on
exec sp_trace_setevent @TraceID, 45, 28, @on
exec sp_trace_setevent @TraceID, 45, 60, @on
exec sp_trace_setevent @TraceID, 45, 5, @on
exec sp_trace_setevent @TraceID, 45, 13, @on
exec sp_trace_setevent @TraceID, 45, 29, @on
exec sp_trace_setevent @TraceID, 45, 61, @on
exec sp_trace_setevent @TraceID, 45, 6, @on
exec sp_trace_setevent @TraceID, 45, 14, @on
exec sp_trace_setevent @TraceID, 45, 22, @on
exec sp_trace_setevent @TraceID, 45, 62, @on
exec sp_trace_setevent @TraceID, 45, 15, @on
exec sp_trace_setevent @TraceID, 44, 7, @on
exec sp_trace_setevent @TraceID, 44, 55, @on
exec sp_trace_setevent @TraceID, 44, 8, @on
exec sp_trace_setevent @TraceID, 44, 64, @on
exec sp_trace_setevent @TraceID, 44, 1, @on
exec sp_trace_setevent @TraceID, 44, 9, @on
exec sp_trace_setevent @TraceID, 44, 41, @on
exec sp_trace_setevent @TraceID, 44, 49, @on
exec sp_trace_setevent @TraceID, 44, 10, @on
exec sp_trace_setevent @TraceID, 44, 26, @on
exec sp_trace_setevent @TraceID, 44, 34, @on
exec sp_trace_setevent @TraceID, 44, 50, @on
exec sp_trace_setevent @TraceID, 44, 3, @on
exec sp_trace_setevent @TraceID, 44, 11, @on
exec sp_trace_setevent @TraceID, 44, 35, @on
exec sp_trace_setevent @TraceID, 44, 51, @on
exec sp_trace_setevent @TraceID, 44, 4, @on
exec sp_trace_setevent @TraceID, 44, 12, @on
exec sp_trace_setevent @TraceID, 44, 28, @on
exec sp_trace_setevent @TraceID, 44, 60, @on
exec sp_trace_setevent @TraceID, 44, 5, @on
exec sp_trace_setevent @TraceID, 44, 29, @on
exec sp_trace_setevent @TraceID, 44, 61, @on
exec sp_trace_setevent @TraceID, 44, 6, @on
exec sp_trace_setevent @TraceID, 44, 14, @on
exec sp_trace_setevent @TraceID, 44, 22, @on
exec sp_trace_setevent @TraceID, 44, 30, @on
exec sp_trace_setevent @TraceID, 44, 62, @on
exec sp_trace_setevent @TraceID, 72, 7, @on
exec sp_trace_setevent @TraceID, 72, 4, @on
exec sp_trace_setevent @TraceID, 72, 8, @on
exec sp_trace_setevent @TraceID, 72, 12, @on
exec sp_trace_setevent @TraceID, 72, 60, @on
exec sp_trace_setevent @TraceID, 72, 64, @on
exec sp_trace_setevent @TraceID, 72, 9, @on
exec sp_trace_setevent @TraceID, 72, 33, @on
exec sp_trace_setevent @TraceID, 72, 41, @on
exec sp_trace_setevent @TraceID, 72, 49, @on
exec sp_trace_setevent @TraceID, 72, 6, @on
exec sp_trace_setevent @TraceID, 72, 10, @on
exec sp_trace_setevent @TraceID, 72, 14, @on
exec sp_trace_setevent @TraceID, 72, 26, @on
exec sp_trace_setevent @TraceID, 72, 50, @on
exec sp_trace_setevent @TraceID, 72, 3, @on
exec sp_trace_setevent @TraceID, 72, 11, @on
exec sp_trace_setevent @TraceID, 72, 35, @on
exec sp_trace_setevent @TraceID, 72, 51, @on
exec sp_trace_setevent @TraceID, 71, 7, @on
exec sp_trace_setevent @TraceID, 71, 4, @on
exec sp_trace_setevent @TraceID, 71, 8, @on
exec sp_trace_setevent @TraceID, 71, 12, @on
exec sp_trace_setevent @TraceID, 71, 60, @on
exec sp_trace_setevent @TraceID, 71, 64, @on
exec sp_trace_setevent @TraceID, 71, 9, @on
exec sp_trace_setevent @TraceID, 71, 33, @on
exec sp_trace_setevent @TraceID, 71, 41, @on
exec sp_trace_setevent @TraceID, 71, 49, @on
exec sp_trace_setevent @TraceID, 71, 6, @on
exec sp_trace_setevent @TraceID, 71, 10, @on
exec sp_trace_setevent @TraceID, 71, 14, @on
exec sp_trace_setevent @TraceID, 71, 26, @on
exec sp_trace_setevent @TraceID, 71, 50, @on
exec sp_trace_setevent @TraceID, 71, 3, @on
exec sp_trace_setevent @TraceID, 71, 11, @on
exec sp_trace_setevent @TraceID, 71, 35, @on
exec sp_trace_setevent @TraceID, 71, 51, @on
exec sp_trace_setevent @TraceID, 12, 15, @on
exec sp_trace_setevent @TraceID, 12, 16, @on
exec sp_trace_setevent @TraceID, 12, 1, @on
exec sp_trace_setevent @TraceID, 12, 9, @on
exec sp_trace_setevent @TraceID, 12, 17, @on
exec sp_trace_setevent @TraceID, 12, 6, @on
exec sp_trace_setevent @TraceID, 12, 10, @on
exec sp_trace_setevent @TraceID, 12, 14, @on
exec sp_trace_setevent @TraceID, 12, 18, @on
exec sp_trace_setevent @TraceID, 12, 11, @on
exec sp_trace_setevent @TraceID, 12, 12, @on
exec sp_trace_setevent @TraceID, 12, 13, @on
exec sp_trace_setevent @TraceID, 13, 12, @on
exec sp_trace_setevent @TraceID, 13, 1, @on
exec sp_trace_setevent @TraceID, 13, 9, @on
exec sp_trace_setevent @TraceID, 13, 6, @on
exec sp_trace_setevent @TraceID, 13, 10, @on
exec sp_trace_setevent @TraceID, 13, 14, @on
exec sp_trace_setevent @TraceID, 13, 11, @on
exec sp_trace_setevent @TraceID, 41, 7, @on
exec sp_trace_setevent @TraceID, 41, 15, @on
exec sp_trace_setevent @TraceID, 41, 55, @on
exec sp_trace_setevent @TraceID, 41, 8, @on
exec sp_trace_setevent @TraceID, 41, 16, @on
exec sp_trace_setevent @TraceID, 41, 48, @on
exec sp_trace_setevent @TraceID, 41, 64, @on
exec sp_trace_setevent @TraceID, 41, 1, @on
exec sp_trace_setevent @TraceID, 41, 9, @on
exec sp_trace_setevent @TraceID, 41, 17, @on
exec sp_trace_setevent @TraceID, 41, 25, @on
exec sp_trace_setevent @TraceID, 41, 41, @on
exec sp_trace_setevent @TraceID, 41, 49, @on
exec sp_trace_setevent @TraceID, 41, 10, @on
exec sp_trace_setevent @TraceID, 41, 18, @on
exec sp_trace_setevent @TraceID, 41, 26, @on
exec sp_trace_setevent @TraceID, 41, 50, @on
exec sp_trace_setevent @TraceID, 41, 3, @on
exec sp_trace_setevent @TraceID, 41, 11, @on
exec sp_trace_setevent @TraceID, 41, 35, @on
exec sp_trace_setevent @TraceID, 41, 51, @on
exec sp_trace_setevent @TraceID, 41, 4, @on
exec sp_trace_setevent @TraceID, 41, 12, @on
exec sp_trace_setevent @TraceID, 41, 60, @on
exec sp_trace_setevent @TraceID, 41, 5, @on
exec sp_trace_setevent @TraceID, 41, 13, @on
exec sp_trace_setevent @TraceID, 41, 29, @on
exec sp_trace_setevent @TraceID, 41, 61, @on
exec sp_trace_setevent @TraceID, 41, 6, @on
exec sp_trace_setevent @TraceID, 41, 14, @on
exec sp_trace_setevent @TraceID, 166, 7, @on
exec sp_trace_setevent @TraceID, 166, 55, @on
exec sp_trace_setevent @TraceID, 166, 63, @on
exec sp_trace_setevent @TraceID, 166, 8, @on
exec sp_trace_setevent @TraceID, 166, 64, @on
exec sp_trace_setevent @TraceID, 166, 1, @on
exec sp_trace_setevent @TraceID, 166, 9, @on
exec sp_trace_setevent @TraceID, 166, 41, @on
exec sp_trace_setevent @TraceID, 166, 49, @on
exec sp_trace_setevent @TraceID, 166, 10, @on
exec sp_trace_setevent @TraceID, 166, 26, @on
exec sp_trace_setevent @TraceID, 166, 34, @on
exec sp_trace_setevent @TraceID, 166, 50, @on
exec sp_trace_setevent @TraceID, 166, 3, @on
exec sp_trace_setevent @TraceID, 166, 11, @on
exec sp_trace_setevent @TraceID, 166, 35, @on
exec sp_trace_setevent @TraceID, 166, 51, @on
exec sp_trace_setevent @TraceID, 166, 4, @on
exec sp_trace_setevent @TraceID, 166, 12, @on
exec sp_trace_setevent @TraceID, 166, 28, @on
exec sp_trace_setevent @TraceID, 166, 60, @on
exec sp_trace_setevent @TraceID, 166, 5, @on
exec sp_trace_setevent @TraceID, 166, 21, @on
exec sp_trace_setevent @TraceID, 166, 29, @on
exec sp_trace_setevent @TraceID, 166, 61, @on
exec sp_trace_setevent @TraceID, 166, 6, @on
exec sp_trace_setevent @TraceID, 166, 14, @on
exec sp_trace_setevent @TraceID, 166, 22, @on
exec sp_trace_setevent @TraceID, 40, 7, @on
exec sp_trace_setevent @TraceID, 40, 55, @on
exec sp_trace_setevent @TraceID, 40, 8, @on
exec sp_trace_setevent @TraceID, 40, 64, @on
exec sp_trace_setevent @TraceID, 40, 1, @on
exec sp_trace_setevent @TraceID, 40, 9, @on
exec sp_trace_setevent @TraceID, 40, 41, @on
exec sp_trace_setevent @TraceID, 40, 49, @on
exec sp_trace_setevent @TraceID, 40, 6, @on
exec sp_trace_setevent @TraceID, 40, 10, @on
exec sp_trace_setevent @TraceID, 40, 14, @on
exec sp_trace_setevent @TraceID, 40, 26, @on
exec sp_trace_setevent @TraceID, 40, 30, @on
exec sp_trace_setevent @TraceID, 40, 50, @on
exec sp_trace_setevent @TraceID, 40, 3, @on
exec sp_trace_setevent @TraceID, 40, 11, @on
exec sp_trace_setevent @TraceID, 40, 35, @on
exec sp_trace_setevent @TraceID, 40, 51, @on
exec sp_trace_setevent @TraceID, 40, 4, @on
exec sp_trace_setevent @TraceID, 40, 12, @on
exec sp_trace_setevent @TraceID, 40, 60, @on
exec sp_trace_setevent @TraceID, 40, 5, @on
exec sp_trace_setevent @TraceID, 40, 29, @on
exec sp_trace_setevent @TraceID, 40, 61, @on
exec sp_trace_setevent @TraceID, 73, 7, @on
exec sp_trace_setevent @TraceID, 73, 4, @on
exec sp_trace_setevent @TraceID, 73, 8, @on
exec sp_trace_setevent @TraceID, 73, 12, @on
exec sp_trace_setevent @TraceID, 73, 60, @on
exec sp_trace_setevent @TraceID, 73, 64, @on
exec sp_trace_setevent @TraceID, 73, 9, @on
exec sp_trace_setevent @TraceID, 73, 33, @on
exec sp_trace_setevent @TraceID, 73, 41, @on
exec sp_trace_setevent @TraceID, 73, 49, @on
exec sp_trace_setevent @TraceID, 73, 6, @on
exec sp_trace_setevent @TraceID, 73, 10, @on
exec sp_trace_setevent @TraceID, 73, 14, @on
exec sp_trace_setevent @TraceID, 73, 26, @on
exec sp_trace_setevent @TraceID, 73, 50, @on
exec sp_trace_setevent @TraceID, 73, 3, @on
exec sp_trace_setevent @TraceID, 73, 11, @on
exec sp_trace_setevent @TraceID, 73, 35, @on
exec sp_trace_setevent @TraceID, 73, 51, @on
exec sp_trace_setevent @TraceID, 198, 7, @on
exec sp_trace_setevent @TraceID, 198, 47, @on
exec sp_trace_setevent @TraceID, 198, 8, @on
exec sp_trace_setevent @TraceID, 198, 64, @on
exec sp_trace_setevent @TraceID, 198, 1, @on
exec sp_trace_setevent @TraceID, 198, 5, @on
exec sp_trace_setevent @TraceID, 198, 9, @on
exec sp_trace_setevent @TraceID, 198, 41, @on
exec sp_trace_setevent @TraceID, 198, 49, @on
exec sp_trace_setevent @TraceID, 198, 6, @on
exec sp_trace_setevent @TraceID, 198, 10, @on
exec sp_trace_setevent @TraceID, 198, 14, @on
exec sp_trace_setevent @TraceID, 198, 26, @on
exec sp_trace_setevent @TraceID, 198, 50, @on
exec sp_trace_setevent @TraceID, 198, 3, @on
exec sp_trace_setevent @TraceID, 198, 11, @on
exec sp_trace_setevent @TraceID, 198, 35, @on
exec sp_trace_setevent @TraceID, 198, 51, @on
exec sp_trace_setevent @TraceID, 198, 4, @on
exec sp_trace_setevent @TraceID, 198, 12, @on
exec sp_trace_setevent @TraceID, 198, 60, @on
exec sp_trace_setevent @TraceID, 19, 7, @on
exec sp_trace_setevent @TraceID, 19, 8, @on
exec sp_trace_setevent @TraceID, 19, 64, @on
exec sp_trace_setevent @TraceID, 19, 1, @on
exec sp_trace_setevent @TraceID, 19, 9, @on
exec sp_trace_setevent @TraceID, 19, 21, @on
exec sp_trace_setevent @TraceID, 19, 25, @on
exec sp_trace_setevent @TraceID, 19, 41, @on
exec sp_trace_setevent @TraceID, 19, 49, @on
exec sp_trace_setevent @TraceID, 19, 2, @on
exec sp_trace_setevent @TraceID, 19, 6, @on
exec sp_trace_setevent @TraceID, 19, 10, @on
exec sp_trace_setevent @TraceID, 19, 14, @on
exec sp_trace_setevent @TraceID, 19, 26, @on
exec sp_trace_setevent @TraceID, 19, 50, @on
exec sp_trace_setevent @TraceID, 19, 3, @on
exec sp_trace_setevent @TraceID, 19, 11, @on
exec sp_trace_setevent @TraceID, 19, 35, @on
exec sp_trace_setevent @TraceID, 19, 51, @on
exec sp_trace_setevent @TraceID, 19, 4, @on
exec sp_trace_setevent @TraceID, 19, 12, @on
exec sp_trace_setevent @TraceID, 19, 60, @on
exec sp_trace_setevent @TraceID, 50, 7, @on
exec sp_trace_setevent @TraceID, 50, 15, @on
exec sp_trace_setevent @TraceID, 50, 8, @on
exec sp_trace_setevent @TraceID, 50, 64, @on
exec sp_trace_setevent @TraceID, 50, 1, @on
exec sp_trace_setevent @TraceID, 50, 9, @on
exec sp_trace_setevent @TraceID, 50, 25, @on
exec sp_trace_setevent @TraceID, 50, 41, @on
exec sp_trace_setevent @TraceID, 50, 49, @on
exec sp_trace_setevent @TraceID, 50, 6, @on
exec sp_trace_setevent @TraceID, 50, 10, @on
exec sp_trace_setevent @TraceID, 50, 14, @on
exec sp_trace_setevent @TraceID, 50, 26, @on
exec sp_trace_setevent @TraceID, 50, 34, @on
exec sp_trace_setevent @TraceID, 50, 50, @on
exec sp_trace_setevent @TraceID, 50, 3, @on
exec sp_trace_setevent @TraceID, 50, 11, @on
exec sp_trace_setevent @TraceID, 50, 35, @on
exec sp_trace_setevent @TraceID, 50, 51, @on
exec sp_trace_setevent @TraceID, 50, 4, @on
exec sp_trace_setevent @TraceID, 50, 12, @on
exec sp_trace_setevent @TraceID, 50, 60, @on
exec sp_trace_setevent @TraceID, 50, 13, @on
exec sp_trace_setevent @TraceID, 50, 21, @on
exec sp_trace_setevent @TraceID, 182, 7, @on
exec sp_trace_setevent @TraceID, 182, 23, @on
exec sp_trace_setevent @TraceID, 182, 31, @on
exec sp_trace_setevent @TraceID, 182, 8, @on
exec sp_trace_setevent @TraceID, 182, 64, @on
exec sp_trace_setevent @TraceID, 182, 1, @on
exec sp_trace_setevent @TraceID, 182, 9, @on
exec sp_trace_setevent @TraceID, 182, 41, @on
exec sp_trace_setevent @TraceID, 182, 49, @on
exec sp_trace_setevent @TraceID, 182, 6, @on
exec sp_trace_setevent @TraceID, 182, 10, @on
exec sp_trace_setevent @TraceID, 182, 14, @on
exec sp_trace_setevent @TraceID, 182, 26, @on
exec sp_trace_setevent @TraceID, 182, 50, @on
exec sp_trace_setevent @TraceID, 182, 3, @on
exec sp_trace_setevent @TraceID, 182, 11, @on
exec sp_trace_setevent @TraceID, 182, 35, @on
exec sp_trace_setevent @TraceID, 182, 51, @on
exec sp_trace_setevent @TraceID, 182, 4, @on
exec sp_trace_setevent @TraceID, 182, 12, @on
exec sp_trace_setevent @TraceID, 182, 60, @on
exec sp_trace_setevent @TraceID, 181, 7, @on
exec sp_trace_setevent @TraceID, 181, 4, @on
exec sp_trace_setevent @TraceID, 181, 8, @on
exec sp_trace_setevent @TraceID, 181, 12, @on
exec sp_trace_setevent @TraceID, 181, 60, @on
exec sp_trace_setevent @TraceID, 181, 64, @on
exec sp_trace_setevent @TraceID, 181, 1, @on
exec sp_trace_setevent @TraceID, 181, 9, @on
exec sp_trace_setevent @TraceID, 181, 41, @on
exec sp_trace_setevent @TraceID, 181, 49, @on
exec sp_trace_setevent @TraceID, 181, 6, @on
exec sp_trace_setevent @TraceID, 181, 10, @on
exec sp_trace_setevent @TraceID, 181, 14, @on
exec sp_trace_setevent @TraceID, 181, 26, @on
exec sp_trace_setevent @TraceID, 181, 50, @on
exec sp_trace_setevent @TraceID, 181, 3, @on
exec sp_trace_setevent @TraceID, 181, 11, @on
exec sp_trace_setevent @TraceID, 181, 35, @on
exec sp_trace_setevent @TraceID, 181, 51, @on
exec sp_trace_setevent @TraceID, 186, 7, @on
exec sp_trace_setevent @TraceID, 186, 23, @on
exec sp_trace_setevent @TraceID, 186, 31, @on
exec sp_trace_setevent @TraceID, 186, 8, @on
exec sp_trace_setevent @TraceID, 186, 64, @on
exec sp_trace_setevent @TraceID, 186, 1, @on
exec sp_trace_setevent @TraceID, 186, 9, @on
exec sp_trace_setevent @TraceID, 186, 21, @on
exec sp_trace_setevent @TraceID, 186, 41, @on
exec sp_trace_setevent @TraceID, 186, 49, @on
exec sp_trace_setevent @TraceID, 186, 6, @on
exec sp_trace_setevent @TraceID, 186, 10, @on
exec sp_trace_setevent @TraceID, 186, 14, @on
exec sp_trace_setevent @TraceID, 186, 26, @on
exec sp_trace_setevent @TraceID, 186, 50, @on
exec sp_trace_setevent @TraceID, 186, 3, @on
exec sp_trace_setevent @TraceID, 186, 11, @on
exec sp_trace_setevent @TraceID, 186, 35, @on
exec sp_trace_setevent @TraceID, 186, 51, @on
exec sp_trace_setevent @TraceID, 186, 4, @on
exec sp_trace_setevent @TraceID, 186, 12, @on
exec sp_trace_setevent @TraceID, 186, 60, @on
exec sp_trace_setevent @TraceID, 185, 7, @on
exec sp_trace_setevent @TraceID, 185, 8, @on
exec sp_trace_setevent @TraceID, 185, 64, @on
exec sp_trace_setevent @TraceID, 185, 1, @on
exec sp_trace_setevent @TraceID, 185, 9, @on
exec sp_trace_setevent @TraceID, 185, 21, @on
exec sp_trace_setevent @TraceID, 185, 41, @on
exec sp_trace_setevent @TraceID, 185, 49, @on
exec sp_trace_setevent @TraceID, 185, 6, @on
exec sp_trace_setevent @TraceID, 185, 10, @on
exec sp_trace_setevent @TraceID, 185, 14, @on
exec sp_trace_setevent @TraceID, 185, 26, @on
exec sp_trace_setevent @TraceID, 185, 50, @on
exec sp_trace_setevent @TraceID, 185, 3, @on
exec sp_trace_setevent @TraceID, 185, 11, @on
exec sp_trace_setevent @TraceID, 185, 35, @on
exec sp_trace_setevent @TraceID, 185, 51, @on
exec sp_trace_setevent @TraceID, 185, 4, @on
exec sp_trace_setevent @TraceID, 185, 12, @on
exec sp_trace_setevent @TraceID, 185, 60, @on
exec sp_trace_setevent @TraceID, 184, 7, @on
exec sp_trace_setevent @TraceID, 184, 23, @on
exec sp_trace_setevent @TraceID, 184, 31, @on
exec sp_trace_setevent @TraceID, 184, 8, @on
exec sp_trace_setevent @TraceID, 184, 64, @on
exec sp_trace_setevent @TraceID, 184, 9, @on
exec sp_trace_setevent @TraceID, 184, 41, @on
exec sp_trace_setevent @TraceID, 184, 49, @on
exec sp_trace_setevent @TraceID, 184, 2, @on
exec sp_trace_setevent @TraceID, 184, 6, @on
exec sp_trace_setevent @TraceID, 184, 10, @on
exec sp_trace_setevent @TraceID, 184, 14, @on
exec sp_trace_setevent @TraceID, 184, 26, @on
exec sp_trace_setevent @TraceID, 184, 50, @on
exec sp_trace_setevent @TraceID, 184, 3, @on
exec sp_trace_setevent @TraceID, 184, 11, @on
exec sp_trace_setevent @TraceID, 184, 35, @on
exec sp_trace_setevent @TraceID, 184, 51, @on
exec sp_trace_setevent @TraceID, 184, 4, @on
exec sp_trace_setevent @TraceID, 184, 12, @on
exec sp_trace_setevent @TraceID, 184, 60, @on
exec sp_trace_setevent @TraceID, 183, 7, @on
exec sp_trace_setevent @TraceID, 183, 4, @on
exec sp_trace_setevent @TraceID, 183, 8, @on
exec sp_trace_setevent @TraceID, 183, 12, @on
exec sp_trace_setevent @TraceID, 183, 60, @on
exec sp_trace_setevent @TraceID, 183, 64, @on
exec sp_trace_setevent @TraceID, 183, 9, @on
exec sp_trace_setevent @TraceID, 183, 41, @on
exec sp_trace_setevent @TraceID, 183, 49, @on
exec sp_trace_setevent @TraceID, 183, 6, @on
exec sp_trace_setevent @TraceID, 183, 10, @on
exec sp_trace_setevent @TraceID, 183, 14, @on
exec sp_trace_setevent @TraceID, 183, 26, @on
exec sp_trace_setevent @TraceID, 183, 50, @on
exec sp_trace_setevent @TraceID, 183, 3, @on
exec sp_trace_setevent @TraceID, 183, 11, @on
exec sp_trace_setevent @TraceID, 183, 35, @on
exec sp_trace_setevent @TraceID, 183, 51, @on
exec sp_trace_setevent @TraceID, 188, 7, @on
exec sp_trace_setevent @TraceID, 188, 23, @on
exec sp_trace_setevent @TraceID, 188, 31, @on
exec sp_trace_setevent @TraceID, 188, 8, @on
exec sp_trace_setevent @TraceID, 188, 64, @on
exec sp_trace_setevent @TraceID, 188, 1, @on
exec sp_trace_setevent @TraceID, 188, 9, @on
exec sp_trace_setevent @TraceID, 188, 21, @on
exec sp_trace_setevent @TraceID, 188, 41, @on
exec sp_trace_setevent @TraceID, 188, 49, @on
exec sp_trace_setevent @TraceID, 188, 6, @on
exec sp_trace_setevent @TraceID, 188, 10, @on
exec sp_trace_setevent @TraceID, 188, 14, @on
exec sp_trace_setevent @TraceID, 188, 26, @on
exec sp_trace_setevent @TraceID, 188, 50, @on
exec sp_trace_setevent @TraceID, 188, 3, @on
exec sp_trace_setevent @TraceID, 188, 11, @on
exec sp_trace_setevent @TraceID, 188, 35, @on
exec sp_trace_setevent @TraceID, 188, 51, @on
exec sp_trace_setevent @TraceID, 188, 4, @on
exec sp_trace_setevent @TraceID, 188, 12, @on
exec sp_trace_setevent @TraceID, 188, 60, @on
exec sp_trace_setevent @TraceID, 187, 7, @on
exec sp_trace_setevent @TraceID, 187, 8, @on
exec sp_trace_setevent @TraceID, 187, 64, @on
exec sp_trace_setevent @TraceID, 187, 1, @on
exec sp_trace_setevent @TraceID, 187, 9, @on
exec sp_trace_setevent @TraceID, 187, 21, @on
exec sp_trace_setevent @TraceID, 187, 41, @on
exec sp_trace_setevent @TraceID, 187, 49, @on
exec sp_trace_setevent @TraceID, 187, 6, @on
exec sp_trace_setevent @TraceID, 187, 10, @on
exec sp_trace_setevent @TraceID, 187, 14, @on
exec sp_trace_setevent @TraceID, 187, 26, @on
exec sp_trace_setevent @TraceID, 187, 50, @on
exec sp_trace_setevent @TraceID, 187, 3, @on
exec sp_trace_setevent @TraceID, 187, 11, @on
exec sp_trace_setevent @TraceID, 187, 35, @on
exec sp_trace_setevent @TraceID, 187, 51, @on
exec sp_trace_setevent @TraceID, 187, 4, @on
exec sp_trace_setevent @TraceID, 187, 12, @on
exec sp_trace_setevent @TraceID, 187, 60, @on
exec sp_trace_setevent @TraceID, 192, 7, @on
exec sp_trace_setevent @TraceID, 192, 23, @on
exec sp_trace_setevent @TraceID, 192, 31, @on
exec sp_trace_setevent @TraceID, 192, 8, @on
exec sp_trace_setevent @TraceID, 192, 64, @on
exec sp_trace_setevent @TraceID, 192, 1, @on
exec sp_trace_setevent @TraceID, 192, 9, @on
exec sp_trace_setevent @TraceID, 192, 41, @on
exec sp_trace_setevent @TraceID, 192, 49, @on
exec sp_trace_setevent @TraceID, 192, 6, @on
exec sp_trace_setevent @TraceID, 192, 10, @on
exec sp_trace_setevent @TraceID, 192, 14, @on
exec sp_trace_setevent @TraceID, 192, 26, @on
exec sp_trace_setevent @TraceID, 192, 50, @on
exec sp_trace_setevent @TraceID, 192, 54, @on
exec sp_trace_setevent @TraceID, 192, 3, @on
exec sp_trace_setevent @TraceID, 192, 11, @on
exec sp_trace_setevent @TraceID, 192, 35, @on
exec sp_trace_setevent @TraceID, 192, 51, @on
exec sp_trace_setevent @TraceID, 192, 4, @on
exec sp_trace_setevent @TraceID, 192, 12, @on
exec sp_trace_setevent @TraceID, 192, 60, @on
exec sp_trace_setevent @TraceID, 191, 7, @on
exec sp_trace_setevent @TraceID, 191, 4, @on
exec sp_trace_setevent @TraceID, 191, 8, @on
exec sp_trace_setevent @TraceID, 191, 12, @on
exec sp_trace_setevent @TraceID, 191, 60, @on
exec sp_trace_setevent @TraceID, 191, 64, @on
exec sp_trace_setevent @TraceID, 191, 1, @on
exec sp_trace_setevent @TraceID, 191, 9, @on
exec sp_trace_setevent @TraceID, 191, 41, @on
exec sp_trace_setevent @TraceID, 191, 49, @on
exec sp_trace_setevent @TraceID, 191, 6, @on
exec sp_trace_setevent @TraceID, 191, 10, @on
exec sp_trace_setevent @TraceID, 191, 14, @on
exec sp_trace_setevent @TraceID, 191, 26, @on
exec sp_trace_setevent @TraceID, 191, 50, @on
exec sp_trace_setevent @TraceID, 191, 3, @on
exec sp_trace_setevent @TraceID, 191, 11, @on
exec sp_trace_setevent @TraceID, 191, 35, @on
exec sp_trace_setevent @TraceID, 191, 51, @on
exec sp_trace_setevent @TraceID, 54, 7, @on
exec sp_trace_setevent @TraceID, 54, 8, @on
exec sp_trace_setevent @TraceID, 54, 24, @on
exec sp_trace_setevent @TraceID, 54, 64, @on
exec sp_trace_setevent @TraceID, 54, 9, @on
exec sp_trace_setevent @TraceID, 54, 21, @on
exec sp_trace_setevent @TraceID, 54, 25, @on
exec sp_trace_setevent @TraceID, 54, 41, @on
exec sp_trace_setevent @TraceID, 54, 49, @on
exec sp_trace_setevent @TraceID, 54, 2, @on
exec sp_trace_setevent @TraceID, 54, 6, @on
exec sp_trace_setevent @TraceID, 54, 10, @on
exec sp_trace_setevent @TraceID, 54, 14, @on
exec sp_trace_setevent @TraceID, 54, 22, @on
exec sp_trace_setevent @TraceID, 54, 26, @on
exec sp_trace_setevent @TraceID, 54, 3, @on
exec sp_trace_setevent @TraceID, 54, 11, @on
exec sp_trace_setevent @TraceID, 54, 35, @on
exec sp_trace_setevent @TraceID, 54, 51, @on
exec sp_trace_setevent @TraceID, 54, 4, @on
exec sp_trace_setevent @TraceID, 54, 12, @on
exec sp_trace_setevent @TraceID, 54, 60, @on


-- Set the Filters
declare @intfilter int
declare @bigintfilter bigint

set @intfilter = 60
exec sp_trace_setfilter @TraceID, 3, 0, 0, @intfilter



exec sp_trace_setfilter @TraceID, 10, 0, 7, N'SQL Server Profiler - ed03094f-7bb0-491e-a9ed-38fa8cada1ab'
exec sp_trace_setfilter @TraceID, 64, 0, 7, N'sqldm'
set @intfilter = 782625831
exec sp_trace_setfilter @TraceID, 22, 0, 0, @intfilter


-- Set the trace status to start
exec sp_trace_setstatus @TraceID, 1

-- display trace id for future references
select TraceID=@TraceID
goto finish

error:
select ErrorCode=@rc

finish:
go













SELECT * FROM ::fn_trace_getinfo (0)

Select * from fn_trace_geteventinfo(5)

select * from fn_trace_getfilterinfo(5)



select * from dbo.schools_2006

select * from dbo.campuscodes

select * from Teleform.Teleform.tfbatmem


exec sp_trace_setstatus 5,0

exec sp_trace_setstatus 5,2

As an alternative to SQL Server Profiler, you can use Transact-SQL system stored procedures to create and run traces. The process of tracing by using system stored procedures is as follows:

1. Create a trace by using sp_trace_create.
   
   
2. Add events with sp_trace_setevent.
   
   
3. (Optional) Set a filter with sp_trace_setfilter.
   
   
4. Start the trace with sp_trace_setstatus.
   
   
5. Stop the trace with sp_trace_setstatus.
   
   
6. Close the trace with sp_trace_setstatus.

The following table lists the system stored procedures for tracing an instance of the SQL Server Database Engine.

Stored procedure	Task performed
fn_trace_geteventinfo (Transact-SQL)	Returns information about events included in a trace.
fn_trace_getinfo (Transact-SQL)	Returns information about a specified trace or all existing traces.
sp_trace_create (Transact-SQL)	Creates a trace definition. The new trace will be in a stopped state.
sp_trace_generateevent (Transact-SQL)	Creates a user-defined event.
sp_trace_setevent (Transact-SQL)	Adds an event class or data column to a trace, or removes one from it.
sp_trace_setstatus (Transact-SQL)	Starts, stops, or closes a trace.
fn_trace_getfilterinfo (Transact-SQL)	Returns information about filters applied to a trace.
sp_trace_setfilter (Transact-SQL)	Applies a new or modified filter to a trace.

SELECT * FROM ::fn_trace_getinfo (0);

Select * from fn_trace_geteventinfo(3);

exec sp_trace_setstatus 3,0

exec sp_trace_setstatus 3,2

Appendix A. SQL script for the server-side trace

/****************************************************/
/* Created by: SQL Server Profiler 2005             */
/* Date: 06/02/2007  11:27:37 AM         */
/****************************************************/

-- Create a Queue
declare @rc int
declare @TraceID int
declare @maxfilesize bigint
set @maxfilesize = 200

-- Please replace the text InsertFileNameHere, with an appropriate
-- filename prefixed by a path, e.g., c:\MyFolder\MyTrace. The .trc extension
-- will be appended to the filename automatically. If you are writing from
-- remote server to local drive, please use UNC path and make sure server has
-- write access to your network share

exec @rc = sp_trace_create @TraceID output, 2, N'd:\ServerSide_Trace', @maxfilesize, NULL
if (@rc != 0) goto error

-- Client side File and Table cannot be scripted

-- Set the events
declare @on bit
set @on = 1
exec sp_trace_setevent @TraceID, 14, 1, @on
exec sp_trace_setevent @TraceID, 14, 9, @on
exec sp_trace_setevent @TraceID, 14, 6, @on
exec sp_trace_setevent @TraceID, 14, 10, @on
exec sp_trace_setevent @TraceID, 14, 14, @on
exec sp_trace_setevent @TraceID, 14, 11, @on
exec sp_trace_setevent @TraceID, 14, 12, @on
exec sp_trace_setevent @TraceID, 15, 15, @on
exec sp_trace_setevent @TraceID, 15, 16, @on
exec sp_trace_setevent @TraceID, 15, 9, @on
exec sp_trace_setevent @TraceID, 15, 13, @on
exec sp_trace_setevent @TraceID, 15, 17, @on
exec sp_trace_setevent @TraceID, 15, 6, @on
exec sp_trace_setevent @TraceID, 15, 10, @on
exec sp_trace_setevent @TraceID, 15, 14, @on
exec sp_trace_setevent @TraceID, 15, 18, @on
exec sp_trace_setevent @TraceID, 15, 11, @on
exec sp_trace_setevent @TraceID, 15, 12, @on
exec sp_trace_setevent @TraceID, 17, 12, @on
exec sp_trace_setevent @TraceID, 17, 1, @on
exec sp_trace_setevent @TraceID, 17, 9, @on
exec sp_trace_setevent @TraceID, 17, 6, @on
exec sp_trace_setevent @TraceID, 17, 10, @on
exec sp_trace_setevent @TraceID, 17, 14, @on
exec sp_trace_setevent @TraceID, 17, 11, @on
exec sp_trace_setevent @TraceID, 10, 15, @on
exec sp_trace_setevent @TraceID, 10, 16, @on
exec sp_trace_setevent @TraceID, 10, 9, @on
exec sp_trace_setevent @TraceID, 10, 17, @on
exec sp_trace_setevent @TraceID, 10, 2, @on
exec sp_trace_setevent @TraceID, 10, 10, @on
exec sp_trace_setevent @TraceID, 10, 18, @on
exec sp_trace_setevent @TraceID, 10, 11, @on
exec sp_trace_setevent @TraceID, 10, 12, @on
exec sp_trace_setevent @TraceID, 10, 13, @on
exec sp_trace_setevent @TraceID, 10, 6, @on
exec sp_trace_setevent @TraceID, 10, 14, @on
exec sp_trace_setevent @TraceID, 12, 15, @on
exec sp_trace_setevent @TraceID, 12, 16, @on
exec sp_trace_setevent @TraceID, 12, 1, @on
exec sp_trace_setevent @TraceID, 12, 9, @on
exec sp_trace_setevent @TraceID, 12, 17, @on
exec sp_trace_setevent @TraceID, 12, 6, @on
exec sp_trace_setevent @TraceID, 12, 10, @on
exec sp_trace_setevent @TraceID, 12, 14, @on
exec sp_trace_setevent @TraceID, 12, 18, @on
exec sp_trace_setevent @TraceID, 12, 11, @on
exec sp_trace_setevent @TraceID, 12, 12, @on
exec sp_trace_setevent @TraceID, 12, 13, @on
exec sp_trace_setevent @TraceID, 13, 12, @on
exec sp_trace_setevent @TraceID, 13, 1, @on
exec sp_trace_setevent @TraceID, 13, 9, @on
exec sp_trace_setevent @TraceID, 13, 6, @on
exec sp_trace_setevent @TraceID, 13, 10, @on
exec sp_trace_setevent @TraceID, 13, 14, @on
exec sp_trace_setevent @TraceID, 13, 11, @on


-- Set the Filters
declare @intfilter int
declare @bigintfilter bigint

exec sp_trace_setfilter @TraceID, 10, 0, 7, N'SQL Server Profiler - 1e3470c1-ba7c-4138-af3d-c96f83654334'
-- Set the trace status to start
exec sp_trace_setstatus @TraceID, 1

-- display trace id for future references
select TraceID=@TraceID
goto finish

error:
select ErrorCode=@rc

finish:
go

Performance Impact: Profiler Tracing vs. Server Side SQL Tracing

http://sqlblog.com/blogs/linchi_shea/archive/2007/08/01/trace-profiler-test.aspx

2010 Office System Driver Beta: Data Connectivity Components

http://www.microsoft.com/downloads/details.aspx?familyid=C06B8369-60DD-4B64-A44B-84B371EDE16D&displaylang=en


.net framework data provider for odbc (EXCEL) (x86)

connection string = Dsn=test;Driver={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)};dbq=c:\book1.xls

.net framework data provider for odbc (EXCEL) (x64)

Driver={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)}

Dsn=test

SQL Syntax for EXCEL

select * from [sheet1$]