Hi, I get the above error message when running a script, how to Enable the MSDTC ? I have set the link server success at my MSSQL server 'MICHELLE' to another two MSSQL server (Server A and ServerB) I need to copy the record from Server A to Server B. I run the Script as below at server 'MICHELLE' : INSERT INTO [Server-B].[ABC].[dbo].[tableMaster] ( Code: ,[Name]) SELECT [Code],[Name] FROM [Server-A].[XYZ].dbo.[tableCustomer] where Code in ( select distinct Code from [Server-A].[XYZ].dbo.[tableInvoice] where CountryCode = 'XXX') anyone can help ? TQ