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...
> How can I create a relationship between tables from two
> different databases in SQL 2000?
> Madhuri
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment