Thinking: 4/11/10

Friday, April 16, 2010

Here are a number of differences. Some are not important, some are real
important and easy to understand, some are real important and hard to
understand. This list is not exhaustive.

DTD's are not namespace
aware.

DTD's have #define, #include, and #ifdef -- or, less
C-oriented, the ability to define shorthand abbreviations, external
content, and some conditional parsing.

A DTD describes the entire
XML document (even if it leaves "holes"); a schema can define portions.

XSD
has a type system.

XSD has a much richer language for describing
what element or attribute content "looks like." This is related to the
type system.

You can put a DTD inline into an XML document, you
cannot do this with XSD. This means DTD's are more secure (you only
have to protect one bytestream -- the xml/dtd -- and not multiple).

The
official definition of "valid XML" requires a DTD. Since this may be
impractical, if not impossible, you often have to settle for
schema-valid, which is not quite the same.

Both DTD (Document Type Definition) and XSD (Xml Schema Definition) intends to do the same thing: define the structure of an XML document.

DTD was introduced in 1999 along with the XML specification. It addresses the following:
1. Define elements, attributes and entities
2. The content model (what is between open tag and closing tag) for each element.
3. The possible attributes for an element
4. The content data type for elements and attributes
5. Entities that can be referenced by an XML
and so on.

As XML became more and more popular, in 2001 W3C standardized XSD to define the structure of an XML with more features:
1. XSD is follows XML syntax
2. Introduced over 40 datatypes
3. constraints on the data (of elements/ attributes)
4. precise no.of occurences of elements
and so on.

The biggest advantage of using an XSD over DTD is that you can specify all your validation rules in an XSD and the parser can check the same for you before the actual application that needs the data gets it.

SOAP TCP/IP Ports

soap-beep 605/tcp SOAP over BEEP
soap-beep 605/udp SOAP over BEEP
# [RFC4744]
netconfsoaphttp 832/tcp NETCONF for SOAP over HTTPS
netconfsoaphttp 832/udp NETCONF for SOAP over HTTPS
# [RFC4743]
netconfsoapbeep 833/tcp NETCONF for SOAP over BEEP
netconfsoapbeep 833/udp NETCONF for SOAP over BEEP

soap-http 7627/tcp SOAP Service Port
soap-http 7627/udp SOAP Service Port

trisoap 10200/tcp Trigence AE Soap Service
trisoap 10200/udp Trigence AE Soap Service

MOS-soap 10543/tcp MOS SOAP Default Port
MOS-soap 10543/udp MOS SOAP Default Port
MOS-soap-opt 10544/tcp MOS SOAP Optional Port
MOS-soap-opt 10544/udp MOS SOAP Optional Port

amt-soap-http 16992/tcp Intel(R) AMT SOAP/HTTP
amt-soap-http 16992/udp Intel(R) AMT SOAP/HTTP
amt-soap-https 16993/tcp Intel(R) AMT SOAP/HTTPS
amt-soap-https 16993/udp Intel(R) AMT SOAP/HTTPS

Wednesday, April 14, 2010

Create Table as Select in SQL Server 2005

SELECT OldTable.*
INTO OldTable_Backup
FROM OldTable

Tuesday, April 13, 2010

How to make a table Read Only in SQL Server.

http://sqlblogcasts.com/blogs/tonyrogerson/archive/2007/08/26/how-to-make-a-table-read-only-in-sql-server.aspx

Moving table to new file group

USE Testing
GO

CREATE TABLE TAB1
(
TAB1_ID INT IDENTITY(1,1),
TAB1_NAME VARCHAR(100),
CONSTRAINT PK_TAB1 PRIMARY KEY(TAB1_ID)
)
GO

INSERT INTO TAB1(TAB1_NAME)
SELECT Table_Name
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_TYPE = 'BASE TABLE'
GO

sp_help TAB1

ALTER TABLE TAB1 DROP CONSTRAINT PK_TAB1 WITH (MOVE TO Second_table)

ALTER TABLE TAB1 ADD CONSTRAINT PK_TAB1 PRIMARY KEY(TAB1_ID) on third_index

SELECT O.Name AS [Object Name], O.[Type], I.name AS [Index name], I.Index_Id, I.type_desc AS [Index Type], F.name AS [Filegroup Name]
FROM sys.indexes I
INNER JOIN sys.filegroups F
ON I.data_space_id = F.data_space_id
INNER JOIN sys.objects O
ON I.[object_id] = O.[object_id]
GO

------------------------

USE Testing
GO

CREATE TABLE TAB2
(
TAB2_ID INT IDENTITY(1,1),
TAB2_NAME VARCHAR(100),
)
GO

CREATE INDEX IDX_TAB2 ON dbo.TAB2(TAB2_ID)
GO

INSERT INTO TAB2(TAB2_NAME)
SELECT Table_Name
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_TYPE = 'BASE TABLE'
GO

sp_help TAB2

---moving table who is has on cluster index to another filegroup

CREATE CLUSTERED INDEX [TAB2_Cluster_Index]
ON [TAB2]([TAB2_ID])
ON [Second_table]

DROP INDEX TAB2.[TAB2_Cluster_Index]

---MOVING NON-CLUSTERED INDEX TO ANOTHER FILEGROUP

CREATE INDEX [IDX_TAB2]
ON [TAB2]([TAB2_ID])
WITH (DROP_EXISTING=ON, ONLINE=ON)
on THIRD_INDEX

---MOVING NON-CLUSTERED INDEX TO ANOTHER FILEGROUP FOR SQL SERVER 2005 STANDARD EDITION
CREATE INDEX [IDX_TAB2]
ON [TAB2]([TAB2_ID])
WITH (DROP_EXISTING=ON)
on THIRD_INDEX

SELECT O.Name AS [Object Name], O.[Type], I.name AS [Index name], I.Index_Id, I.type_desc AS [Index Type], F.name AS [Filegroup Name]
FROM sys.indexes I
INNER JOIN sys.filegroups F
ON I.data_space_id = F.data_space_id
INNER JOIN sys.objects O
ON I.[object_id] = O.[object_id]
GO

--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]

Monday, April 12, 2010

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:

Create a trace by using sp_trace_create.
Add events with sp_trace_setevent.
(Optional) Set a filter with sp_trace_setfilter.
Start the trace with sp_trace_setstatus.
Stop the trace with sp_trace_setstatus.
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

Thinking