Relationships between tables in different database | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Relationships between tables in different database

Can you create relationships between 2 tables in different databases on the same server? If so, how?
You can’t use built-in referential integrity to do this, but you can use triggers to simulate this, although there is a small performance hit for doing this. —————————–
Brad M. McGehee, MVP
Webmaster
SQL-Server-Performance.Com
Also remember that such simulated rules will be potentially violated should you need to restore one database from backup and not the other.
]]>