linked Server triggers not working

[irweazel]

I have set up linked servers and tested and these work fine, able to insert rows etc etc.
But when setting up the triggers so that it takes from the inserted table and does it automatically it comes up with ANSI errors.
I have changed the settings for these, turning them on, off and most possible combinations.
ANSI_NULLS and ANSI_WARNINGS
these are set in the triggers and don't seem to do the trick.
This has been tried with SQL 2000, SQL 2005 SP1. I have even created a new instance to ensure the collations are matching in case that was the issue.
Any suggestions would be really helpful

Cheers

Chris

it's hard to convey five-dimensional ideas in a language evolved to scream defiance at the monkey in the next tree

 

[ptheriault]

I'm not sure but you could check to see if your link server has allow distributed transactions enabled.

- Paul
- If at first you don't succeed, find out if the loser gets anything.

 

[mrdenny]

Try enabling XACT_ABORT within the trigger and/or the calling code.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com