That server then breaks down the query (exactly as your server did) and passes whatever SQL it needs to whatever linked servers it has.

You can also use distributed transactions whenever there's SQL Server to SQL Server communication and changes will be made to data during the course of the transaction, often done via a linked server.

Hello,I have a problem I cannot figure out. I am trying to update 2 fields (InvoiceNumber and Invoicedate) in a table on a linked server ([CLAIMS].DB.dbo.MFrameEClaims) with data from a local ...