Welcome to Sign in | Join | Help

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

  •  09-21-2006, 3:44 PM

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

    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

     

     

    Cristian Andrei Lefter, SQL Server MVP
    MCT, MCSA, MCDBA, MCAD, MCSD .NET,
    MCTS, MCITP - Database Administrator SQL Server 2005
    http://sqlserver.ro
    Filed under:
View Complete Thread
Powered by Community Server (Commercial Edition), by Telligent Systems