Across database Constraint | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Across database Constraint

Hi 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
The website isn’t terribly informative in that respect. Do you know who is behind this product? —
Frank Kalis
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