Hi
I have the folowing requirement;
When an email address is updated on a Contact record, a stored procedure should be executed on another database (not the dyn crm database).
Is it a supported / recommended solution to add a SQL trigger to the CRM database which exec the stored proc on the other database
or
is it preferred to write a plugin for CRM and then exec the sproc from the plugin?
The latter seems like alot more work.