SQL Server Performance

Error msg : MSDTC on Server 'MICHELLE' unavailable

Discussion in 'SQL Server 2008 General DBA Questions' started by michellesbs, Jan 24, 2010.

  1. michellesbs New Member

    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
    
  2. Luis Martin Moderator

    Check:http://geekswithblogs.net/narent/archive/2006/10/09/93544.aspx

Share This Page