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

commit tran

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...