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.

I have a linked server and I'm having a tough time referencing it properly.If I open SQL Management Studio and run a query on the server itself it works great.However, I want to take that query ...