SQL Server Performance Forum – Threads Archive
Across database ConstraintHi all,
Is it possible to create foreign key constraint across database?
If pubs database having authors table, will i create the references from nortwind. can u pls help me out for this situation?
Thanks in advance
No. Roji. P. Thomas
there’s a beta version of a new 3rd-party product that can do this, you can have a look at it here http://www.remote-keys.com
The website isn’t terribly informative in that respect. Do you know who is behind this product? —
Microsoft SQL Server MVP
Thank you very much Thomas
No, I don’t know who’s behind it. I found the link by chance on the MS newsgroups & thought the original poster might find it useful.
Anybody tried this? and how does it work?
The only way I can think of is instead of triggers. Roji. P. Thomas
I suspect it uses triggers, the FAQ on the website is a bit evasive in the "how does it work?" question.
Not sure you such triggers must be "instead of" – "for" will work just fine.
I had same requirment I used triggers for that —————————————-
Contributing Editor, Writer & Forums Moderator
http://www.SQL-Server-Performance.Com Visit my Blog at
Using triggers, its working fine.
Thank you very much dineshasanka