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.

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

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de