var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Come on...Somebody help with Relationship two Databases
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
Recife - PE - Brazil
You would have to do this via triggers, or by making all data changes through stored procedures that maintain relational integrity.