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 2005 Forums
 Transact-SQL (2005)
 Enforcing foreign key constraint on tables

Author  Topic 

Abu-Dina
Posting Yak Master

206 Posts

Posted - 2008-03-05 : 05:07:57
Greetings all!

How can I enforce a foreign key constraint when I have two tables each one residing on a different database?

Thanks for your help in advance.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-03-05 : 05:28:37
You might have to write an INSTEAD OF trigger to enforce this constraint across databses.
Go to Top of Page
   

- Advertisement -