Can anyone help explain 'XactSequence' in profiler trace

Hi All

Can you explain the column 'XactSequence' in detail in SQL Server 2005 profiler trace?

Thanks in advance.

transaction sequence.

|||

Thanks, can you let me know the difference between transaction sequence and transaction id? Also, for dtc transaction, does it have transaction sequence?

|||

They're not the same. Think of a sql job where you have multiple job steps. So, the jobid is not the same as the jobstepid. It's a 1-to-many relationship.

|||

Thanks. But when will SQL create a XactSequence for the specified SQL transaction? Also, will DTC transaction have XactSequence?

Can a profiler trace be scheduled?

I need to run a Sql Profiler Trace on one of our sql server 2000 instances at 3:00 AM but rather than getting up at 3, I would rather schedule a trace to run. Can this be done? If so, where can I see an example?

Thanks

Yes.. you can do that... You can write your own script using sql tracing SP and functions.

Read :http://msdn2.microsoft.com/en-us/library/ms191006.aspx

http://vyaskn.tripod.com/server_side_tracing_in_sql_server.htm

The other way is ... you make a trace using the Profiler Tool and then you can script it. Once you create the script run the script using job...

Madhu