Link SQL tables across multiple databases

[jcalli]

Hi,

I need to link SQL Server tables across SQL Server databases. I know how to do this using a view, but is there another way to do this? Is there any way to link tables administratively using enterprise manager? (similar to Access).

Thanks in advance.

 

[DrSql]

select * from dbname.owner.tablename will give you the tables. You cann call from any db's as long as permissionms set to it. But I am not sure you can see the tables as a part of the db tables. Work around is create view with all the tables.

Dr.Sql
Good Luck.

 

[mrdenny]

You can't create forign keys accross databases (which is what happens when you make a database diagram and create the links). Forign Keys can only be created on objects within the same database.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

Donate to Katrina relief