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