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" via Tiggers?

How´s the sentence for this tigger?

Thanks for attetion

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