Configuring a Linked Microsoft Access Server on SQL 2005 Server - Finding information about Linked Servers
(Page 3 of 6 )
Finding the login information
At times you may want to know the login mapping, and you can execute the stored procedure sp_helplinkedsrvlogin as shown, which shows the login information for all the linked servers. This stored procedure without any input value gives the login information, both local and remote, for all linked servers.
However if you want to find the information for any one linked server, you may pass an argument, which produces the result as shown.
Finding the tables in the Linked Server
At times before you run a query you may want to know what tables there are in the database. For this you would run the sp_tables_ex stored procedure, passing the Linked Server as an argument as shown with results.
Finding the columns in a table on the Linked Server
Again for scripting your query you may need the columns in a database and related information. Then you would run the sp_columns_ex query, passing the linked server and the table as arguments.
Finding Primary and Foreign Keys
Similarly you can find information about the primary and foreign keys for a table as shown in the next two pictures.
Finding the Indexes on a table
The following picture shows how to access indexes on a table in the linked server.
Next: Setting linked server options >>
More Microsoft Access Articles
More By Jayaram Krishnaswamy
