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
    Jeyakumar
  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
    Moderator
    Microsoft SQL Server MVP
    Webmaster:http://www.insidesql.de
  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
    http://www.SQL-Server-Performance.Com

    Visit my Blog at
    http://dineshasanka.spaces.live.com/
  11. jeyakumars New Member

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

Share This Page