How to update remote server tables value with the help of triggers??
Posted on 2011-02-23
I have 2 servers , 1 internal server and 1 external .
All the updations and insertion done on internal server only , My need is to update
the external server with the help of Triggers only.
I can't go for Replication kind of things because that's were not included in the agreement.
Client doesn't allow us to that.
So i just decided to go for triggers , if anyone can give better idea Please help.
Otherwise please provide me some sample scripts which help me doing automatically update the client server.
Note: Client server is linked with our internal server via linked server option.