Need Linked Server to show more db tables

Moved a database over to a new SQL server. That database had a couple
of stored procedures that call two different databases. I linked the
servers, but I know that the tables that show up correspond to the
default database on the security account i have setup to connect to the
server. Is there any way to allow connections to other databases/tables
with the same link?
You can connect to more than just what you see - just use
the four part name qualifier of:
LinkedServerName.Database.Owner.Object
That's controlled by permissions, not by what you "see" in
Enterprise Manager listed as the tables for the linked
server. The tables displayed are based on what the default
database for the login is if you have not specified a
Catalog (database) for the linked server property. If you
want to change the database you are initially connected to,
enter the database name in the Catalog property for the
linked server.
-Sue
On 17 Oct 2005 13:42:22 -0700, danny.spence@.gmail.com wrote:

>Moved a database over to a new SQL server. That database had a couple
>of stored procedures that call two different databases. I linked the
>servers, but I know that the tables that show up correspond to the
>default database on the security account i have setup to connect to the
>server. Is there any way to allow connections to other databases/tables
>with the same link?