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?

callinga web service?

Hi All
can i in call a web service from SP/function
(without using COM SP's) in any way ?
and represent the returned xml as a resultset ?
TIA
Danny
I don't think this is possible in SQL Server 2000 without using the sp_OA
procs or writing an extended stored proc.
In Yukon, you can write a CLR UDF.
Best regards
Michael
"Danny" <danny.ravid@.ness.com> wrote in message
news:eb2d01c43cee$7257dba0$a301280a@.phx.gbl...
> Hi All
> can i in call a web service from SP/function
> (without using COM SP's) in any way ?
> and represent the returned xml as a resultset ?
> TIA
> Danny