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

server, stored procedure and Views (Heterogeneous Error

I am using SQL passthough and simply running an "exec mysproc".
Then I simply run a "Select * from myView", which is a "Select a,b,c from
xxx.xxx.dbo.table"
This all runs vis MS Query, but if I turn off ANSI NULLS and WARNINGS in the
MS Query options, I get the same error.
"Uri Dimant" wrote:

> Ray
> Can you show us how you call the statemnet?
>
> "Ray" <rayc@.rsc.com> wrote in message
> news:FEEE24DA-571B-4C46-887B-33D4F772553E@.microsoft.com...
>
>Ray
You said that it failed from within a trigger. Try create a trigger
withANSI NULLS and WARNINGS set ON
What is your statement to fire a trigger?
"Ray" <rayc@.rsc.com> wrote in message
news:3CA11337-A751-449C-815A-35AEF75416C8@.microsoft.com...
>I am using SQL passthough and simply running an "exec mysproc".
> Then I simply run a "Select * from myView", which is a "Select a,b,c from
> xxx.xxx.dbo.table"
> This all runs vis MS Query, but if I turn off ANSI NULLS and WARNINGS in
> the
> MS Query options, I get the same error.
> "Uri Dimant" wrote:
>