Hello,
I am trying to modify a trigger to update tables in another database on the same sql server. Currently the triggers fires when ever the customer ID is updated, all related tables in the accounting program are updated. My problem is that we have an application that handles Service type transactions. The tables are stored in another database on the same sql server. i need to modify the trigger so it references the tables in the Service database and updates the customer ID in open orders, Service History and open quotes. Need some help.
Thanks,
Lou
I am trying to modify a trigger to update tables in another database on the same sql server. Currently the triggers fires when ever the customer ID is updated, all related tables in the accounting program are updated. My problem is that we have an application that handles Service type transactions. The tables are stored in another database on the same sql server. i need to modify the trigger so it references the tables in the Service database and updates the customer ID in open orders, Service History and open quotes. Need some help.
Thanks,
Lou