SQL Server Performance

Across database Constraint

Discussion in 'SQL Server 2005 General Developer Questions' started by jeyakumars, Nov 22, 2006.

  1. jeyakumars New Member

    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
  2. Roji. P. Thomas New Member

  3. thomas New Member

  4. FrankKalis Moderator

    The website isn't terribly informative in that respect. Do you know who is behind this product?

    Frank Kalis
    Microsoft SQL Server MVP
  5. jeyakumars New Member

    Thank you very much Thomas
  6. thomas New Member

    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.
  7. Roji. P. Thomas New Member

  8. thomas New Member

    I suspect it uses triggers, the FAQ on the website is a bit evasive in the "how does it work?" question.
  9. Adriaan New Member

    Not sure you such triggers must be "instead of" - "for" will work just fine.
  10. dineshasanka Moderator

    I had same requirment I used triggers for that

    Contributing Editor, Writer & Forums Moderator

    Visit my Blog at
  11. jeyakumars New Member

    Using triggers, its working fine.
    Thank you very much dineshasanka

Share This Page