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

When using linked servers, I believe, all processing occurs on the calling server. For processing to occur on the linked server you would use OpenQuery.

Distributed transactions are one of the more powerful and important functions within SQL Server. A distributed transaction is just like any other transaction within the SQL Server database, with a ...

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. A fundamental skill for DBAs is to have ...