Testing the connection to the Microsoft SQL Server remote server
Test the connection to the Microsoft SQL Server remote server to determine if the federated server is properly configured to access Microsoft SQL Server data sources.
About this task
You can test the connection to the Microsoft SQL Server remote server by using the server definition and user mappings that you defined.
Procedure
Open a pass-through session and issue a SELECT statement
on the Microsoft SQL Server system tables.
If the SELECT statement returns a count, your server definition
and your user mapping are set up properly.
For example:
SET PASSTHRU server_definition_name
SELECT count(*) FROM dbo.sysobjects
SET PASSTHRU RESET