Linked tables

Hi,
I am new to SQL Server 2000 and am looking for examples of how to do the
following:
I have a set of 27 tables, 22 of which are supporting tables and 5 tables
that are transactional in nature. These are currently in the same database.
We are small and have only one server.
Everything is fine until.... My company decided to do out-source work for
other companies that are similar to us. This means that with the
application setup the way it is, I need to create a different set of tables
for each customer. The supporting tables are huge, so I would like to be
able to put them into their own database and make them accessible from every
company's database.
In Access XP I would click "Get external data","Link Tables" and select the
database and tables I wanted to link to the company specific tables. I
can't figure out how to do this in SQL Server.
Is there a way to do this in SQL Server?
Remember I am a big time novice, so keep it simple.
Thanks
LanceSQL Server supports linked servers, which aren't the same thing at all
(see the distributed querying topics in Books Online for more info).
You can create views and stored procedures in one database that
reference tables in another database by using the
databasename.ownername.objectname syntax as long as the databases are
all on the same server, which may be what you are looking for.
-- Mary
Microsoft Access Developer's Guide to SQL Server
http://www.amazon.com/exec/obidos/ASIN/0672319446
On Fri, 16 Jan 2004 13:39:10 -0800, "Lance Geeck" <lgeeck@.cox.net>
wrote:
>Hi,
>I am new to SQL Server 2000 and am looking for examples of how to do the
>following:
>I have a set of 27 tables, 22 of which are supporting tables and 5 tables
>that are transactional in nature. These are currently in the same database.
>We are small and have only one server.
>Everything is fine until.... My company decided to do out-source work for
>other companies that are similar to us. This means that with the
>application setup the way it is, I need to create a different set of tables
>for each customer. The supporting tables are huge, so I would like to be
>able to put them into their own database and make them accessible from every
>company's database.
>In Access XP I would click "Get external data","Link Tables" and select the
>database and tables I wanted to link to the company specific tables. I
>can't figure out how to do this in SQL Server.
>Is there a way to do this in SQL Server?
>Remember I am a big time novice, so keep it simple.
>Thanks
>Lance
>