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

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

So you decided to set up log shipping in order to establish a failover server, but what's next? Log shipping only takes care of keeping a user database in sync from one server to the other. In the ...