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 ...

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.

Is it possible to use linked services in MSSQL Server and execute queries if the Distributed Transaction Coordinator is not enabled?Maybe this should be in the NT forum, but I thought writing ...

A fundamental skill for DBAs is to have a firm understanding of the SQL Server database engine's system databases. Tim Chapman discusses these system databases.

Establishing a failover server for your SQL Server? First things, first: strategize on your logins.

This wait type may also indicate the SPID is waiting for remote procedure calls, linked server queries, BULK INSERT commands, or full-search queries. PAGEIOLATCH_* —Buffer latches, including the ...