Unanswered: How many statements can thr be in a distributed transaction
I am currently trying to run a trigger which can updata/insert into tables which are in another server...as suggested by many references i created a linked server and I am referencing using a four part name eg. insert into linkedservername.dbname.dbo.tablename. I have about 4 insertions to different tables in one transaction. i.e
Begin distributed tran
insert into lnkserv.dbname.dbo.table1
insert into lnkserv.dbname.dbo.table2
Is it ok to have many insertions in one transaction or is there a limit?
I run into an error saying that SQLOLEDB cannot start the distributed transaction.
WHY? Someone pls help me ....I am at a big loss of what to do...