We've been working with a Linked Server between our BaanV database and an outside database both on SQL Server. By putting the Baan table aside and using a view in its place I am able to read the table from the other db, but cannot update it.

Our DBA feels that if I can call the below DB statements prior to my select then an update will be possible.

begin distributed tran
SET XACT_ABORT ON

Anyone had any experience with it?

Thanks,
Bob