Multiple choice technology databases

What are the different options in SQL Server 2005 for accessing a Linked Server?

  1. (a) Distributed Queries

  2. (b) OPENROWSET function

  3. (c) Remote Stored Procedures

  4. (d) Execute Statement

  5. (e) All of the above
Reveal answer Fill a bubble to check yourself
A,C,D Correct answer
Explanation

SQL Server 2005 provides three main methods to access a Linked Server: Distributed Queries using four-part naming convention (LinkedServer.Database.Schema.Table), Remote Stored Procedures that execute directly on the linked server, and the EXECUTE statement with the AT Linked Server clause for pass-through queries. OPENROWSET is an ad-hoc method that doesn't require a predefined linked server, making it distinct from these linked server-specific access methods.

Keep practicing — related questions