I Forgot about CASCADE, that would complete the solution, imagine playing a malicious user in one database and watch the stupefied faces of the users in the other db :)
Can you write tri-directional triggers as well
rockmoose /* Chaos is the nature of things...Order is a lesser state of chaos */
If not for a cross-database permissions problem, I'd have everything working great, but I freely admit that the way I'm doing it is not ideal for most situations. If my company were much larger and everything were on a much larger scale, I certainly would reconsider the bidirectional trigger solution. Thanks again all, and may the Norse be with you, always.
trigger to keep tables matching
Posted - 09/21/2004 : 11:54:02
