Linked servers without MSDTC?

Hot Topic

Connecting SQL 2005 Mgt STudio through a Cisco Firewall
Data Type
spreading data choosing a determined NDF???
Stored Procedures, 'GO', and transactions/atomicity
Merge replication columns limit??
Execute DTS Package
Display Last 2 Comments to a Record
trace file
Script Task Variables
problem in linked server to access with secure system.mdw

SQL Server

Report - preview looks fine, but exporting to PDF splits controls!!!Help!!
Adding assembly file to AS database via AMO
Data-Driven Subscriptions
Restoring database from MS SQL 2000 to SQL Express 2005
drill-down in excel format
SP2 SQL Server 2005 Error 29528
Transferring Objects from 2000 to 2005
i'm sorry man no was my intention
Is it possible to send email to SQL Server 2005?
Insert trigger for bulk insert

Linked servers without MSDTC?

Simply put is it possible

Will all transactions that involve a linked server connection by promoted to a Distributed transaction or can you set something somewhere that will keep the transaction 'normal'

Thanks in advance.

Dave

Answer this question

Linked servers without MSDTC?

Torsten_Katthoefer
To ensure consistency across the server MSDTC will be needed and automatically involved.

HTH, Jens K. Suessmeyer.

---
http://www.sqlserver2005.de
---
Linked servers without MSDTC?

Answer this question