I need to have the following functionality and I'm wondering how to accomplish it (I've tried Googling, not having much luck):
From a trigger in one database on SERVER1, I need to be able to connect to and execute a Stored Proc in a database on SERVER2. Any idea what needs to be done to accomplish this?
TIA,
~~Bonnie