cross-database relationship

How can I create a relationship between tables from two
different databases in SQL 2000?
MadhuriThis is not possible with declarative referential integrity (foreign keys).
You need to use triggers to enforce the relationship.
Hope this helps.
Dan Guzman
SQL Server MVP
"Madhuri Mittal" <madhurimittal@.yahoo.com> wrote in message
news:03c001c3d709$9c920a80$a401280a@.phx.gbl...

quote:

---

> How can I create a relationship between tables from two
> different databases in SQL 2000?
> Madhuri

---

|||Dan,
Thanks a lot- could you point me to some good documentation and books
that explain how to create such triggers? Thanks again
Madhuri
*** Sent via Developersdex http://www.examnotes.net ***
Don't just participate in USENET...get rewarded for it!|||Here's a link to a list of many of the more popular SQL Server books.
http://www.sql-server-performance.com/reviews.asp
Itzik Ben-Gan and Thomas Moreau have some examples of cascading RI triggers
in their white paper:
<http://www.msdn.microsoft.com/libra...ry/en-us/dnsql2
k/html/sql_refintegrity.asp?frame=true>.
Hope this helps.
Dan Guzman
SQL Server MVP
"Madhuri Mittal" <madhurimittal@.yahoo.com> wrote in message
news:uxTyEB51DHA.4064@.tk2msftngp13.phx.gbl...

quote:

---

> Dan,
> Thanks a lot- could you point me to some good documentation and books
> that explain how to create such triggers? Thanks again
> Madhuri
>
> *** Sent via Developersdex http://www.examnotes.net ***
> Don't just participate in USENET...get rewarded for it!
>

---