Can triggers effect remote databases?

Is it possible to create a trigger on a MS/SQL database to update a remote MySQL database, or are triggers intended to make local changes only?
Who is Participating?
nito8300Connect With a Mentor Commented:
you can try to do something like
Update MySQL.Database.Table
Set Field1 = 'Your Value'

You would have to add the server as a linked server.
dqmqConnect With a Mentor Commented:
While I can't claim it's advisable, it's certainly possible for a trigger to update a database on a linked server. This should head you the right direction:
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.