Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Creating an Update Trigger - Between Databases

Status
Not open for further replies.

jcg6

Technical User
Feb 18, 2002
50
US
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. :)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top