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.

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

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

SQL Server has a long list of roles for server, database, and applications that outline things like permissions, data selection and modification, and disk management. Examine how roles play a part in ...

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