I have two tables in seperate databases on SQL Server 2000.
One table contains Sales Orders
When I insert update or delete a row in the Sales Order I want a row to be inserted, updated or deleted with the same Sales Order Number
The Column name is OrdLineNo
Can you have diagrams that refer to tables across different databases or does this need to be achieved with a trigger?
Any comments greatly appreciated