Join | Login | Why Join?   
SQL Server, Oracle, DB2, Sybase, MySQL Help - SSWUG.ORG HACKER SAFE certified sites prevent over 99.9% of hacker crime.
Search SSWUG:   
 
Access to 471 free guest articles, discussions and more, just create your free SSWUG User ID:
Email address:  
This will be your login ID - we'll email you your password - you'll even receive the newsletter, opt-out at any time.
Email to Friend //  Discuss Article //  Rate Article //  Digg Article //  Add to Del.icio.us //  Add to Technorati

 

XPDTC.DLL - DTC transaction information

Available for Members. This is an off-site link.  Please review our Terms of Service (bottom of page) for additional information.  See Related Articles


 Article Abstract:

XPDTC provides a way to retrieve information about the fact if the current context in which the extended stored procedure (xp_dtc_tx_info) is executed, is part of a distributed transaction or not. When part of a distributed transaction, the XP can retrieve the transaction object and return the transaction ID which uniquely identifies the MS-DTC transaction, the transaction timeout and the transaction description.

This information is very useful when you need to troubleshoot distributed transaction and correlate transaction back to COM+ or MS-DTC based on the Transaction ID.

 Read this article...

 Related Articles - For Members.
PRB: Cluster Group Containing SQL Server and MS DTC Moves Slowly
Enhance Your Transaction Flexibility With Embedded Stored Procedures
Error message when you run a distributed query against a loopback linked server in SQL Server 2005: 'Transaction context in use by another session'
Error message when you commit a distributed transaction that contains a query that retrieves data from a linked server in SQL Server 2005
Troubleshooting SQL Server 2000 installation
Linked Severs on MS SQL Part 3
Troubleshooting SQL Server 7.0 installation issues
The comparison of SQL Server 6.5 with SQL Server 7.0
Troubleshooting SQL Server Profiler



Key (Please note):
(R) - registration may be required for access at the target site
($) - target site may require paid membership for access to this or other content


No Comments/Feedback Posted Yet. Post Your Comments/Feedback

Email to Friend //  Discuss Article //  Rate Article //  Digg Article //  Add to Del.icio.us //  Add to Technorati

   




 

[ Register ] [ Webcasts ] [ Podcasts ] [ Newsletter Archive ] [ RSS/Feeds ]
[ About ] [ Advertise ] [ Contact ] [ Privacy ] [ Terms of Service ]
[ Link to SSWUG ] [ List Server Archives ] [ Recent Orig. Content ]
(c) 1997-2008, Bits on the Wire, Inc.  (0)

Some names and products covered by SSWUG are the registered trademarks of their respective owners.
DAA10354WWW004