the operation could not be performed because ole db provider sqlncli10 for linked server
Question 1: Execute this Query in SQL server where you setup database. Answer: EXEC sp_serveroption @Server='DB Server IP Address',@optname='remote proc transaction promotion', @optvalue='false' try this SQL above your begin distributed transaction set XACT_ABORT on