I need to create a trigger that fires whenever the MachineID column is updated in my HardwareDB. I want this trigger to update any related MachineIDs in another database (SoftwareDB). I have tried some syntax, but I haven't had any success yet. Here is exactly what I need:
DB1 - HardwareDB
Column - MachineID
DB2 - SoftwareDB
Column - MachineID
Whenever the MachineID column is changed in DB1 I want any records with that same MachineID in the SoftwareDB to be updated as well. Could someone assist me in creating a trigger that will do this. I know that it is simple, but I am new with this. Thanks very much.
DB1 - HardwareDB
Column - MachineID
DB2 - SoftwareDB
Column - MachineID
Whenever the MachineID column is changed in DB1 I want any records with that same MachineID in the SoftwareDB to be updated as well. Could someone assist me in creating a trigger that will do this. I know that it is simple, but I am new with this. Thanks very much.