Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Administration (2000)  Link Tables Between 2 SQL Server Databases

Author  Topic  dgraham Starting Member 1 Post Posted - 2001-09-17 : 18:38:39 How can I link tables between 2 sql server databases on the same server? This is quite easy to do in Access so I assume there is a way in sql server. I know I can get to the data in another database by doing this: select * from mydatabase.dbo.mytable; but I need to enforce structure on the linked data (ie. foreign keys). Thanks for any help.