Question of the Day

Re: QOD 70-431 2006-09-21 Objective: Installing and Configuring SQL Server 2005 - Identify the external data source.

xmldeveloper — Sun, 05 Nov 2006 13:46:04 GMT

Correct! The right answer is: TestSrv.AdventureWorks.Sales.SalesOrderDetail

Re: QOD 70-431 2006-09-21 Objective: Installing and Configuring SQL Server 2005 - Identify the external data source.

crestinul — Sat, 04 Nov 2006 19:39:36 GMT

testsrv.adventureworks. Sales.SalesOrderDetails

QOD 70-431 2006-09-21 Objective: Installing and Configuring SQL Server 2005 - Identify the external data source.

xmldeveloper — Thu, 21 Sep 2006 12:44:34 GMT

You want to create a stored procedure that will access a remote SQL Server named TestSrv.You add the TestSrv as a linked server using the following code:

USE master;
GO
EXEC sp_addlinkedserver 
   'TestSrv',
   N'SQL Server'
GO

You want to select data using the local stored procedure from the Sales.SalesOrderDetails table located in the remote database AdventureWorks.
How should you specify the table name ?

Place the mouse cursor HERE for the answer

Reference: http://msdn2.microsoft.com/en-us/library/ms190406.aspx