Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003
    Location
    Recife - PE - Brazil
    Posts
    28

    Exclamation Unanswered: Come on...Somebody help with Relationship two Databases

    Relationship Databases
    Hi,
    I have a DataBase called "ServerInformation" where there´s a table called "Clients"

    Another database aplication "Index2003" using the same SQL Server, will acess the information in the table "Clients" from then "ServerInformation" Database.

    My question is.... How can I ensure data integrity using a relationship that "cascade update related Fields" from two different databases in the field "ID_Client" when it´s equal fields in :

    Index2003 - > Documents - > ID_Clients
    ServerInformation - > Clients - > ID_Clients

    How can I do the relationship of two tables in different databases?

    Thanks for attetion

    Leonardo Almeida
    Recife - PE - Brazil
    55-81-9152-5106

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    You would have to do this via triggers, or by making all data changes through stored procedures that maintain relational integrity.

    blindman

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •