Welcome to Sign in | Help
in Search

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

Last post 11-05-2006, 3:46 PM by xmldeveloper. 2 replies.
Sort Posts: Previous Next
  •  09-21-2006, 3:44 PM 131

    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:
  •  11-04-2006, 9:39 PM 736 in reply to 131

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

    testsrv.adventureworks. Sales.SalesOrderDetails
    Secolul XXI ori va fi religios ori nu va fi deloc
  •  11-05-2006, 3:46 PM 745 in reply to 131

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

    Correct! The right answer is: TestSrv.AdventureWorks.Sales.SalesOrderDetail
    Cristian Andrei Lefter, SQL Server MVP
    MCT, MCSA, MCDBA, MCAD, MCSD .NET,
    MCTS, MCITP - Database Administrator SQL Server 2005
    http://sqlserver.ro
View as RSS news feed in XML
Powered by Community Server (Commercial Edition), by Telligent Systems