How to update remote server tables value with the help of triggers??

Posted on 2011-02-23
Medium Priority
Last Modified: 2012-12-09
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.
Question by:SinghAmandeep
LVL 11

Expert Comment

ID: 34967994

Create a linked server. You can update external server table with linked server.
LVL 57

Accepted Solution

Raja Jegan R earned 1000 total points
ID: 34971127
>> Note: Client server is linked with our internal server via linked server option.

Since you have enabled Linked Server, next things to proceed were

1. Enable MSDTC in both SQL Server machines.


2. Update SQL Server to SP4 because few issues related to DTC were fixed in SP2

Now try creating trigger which can help..

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

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.

Join & Write a Comment

In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
SQL Database Recovery Software repairs the MDF & NDF Files, corrupted due to hardware related issues or software related errors. Provides preview of recovered database objects and allows saving in either MSSQL, CSV, HTML or XLS format. Ensures recov…
Stellar Phoenix SQL Database Repair software easily fixes the suspect mode issue of SQL Server database. It is a simple process to bring the database from suspect mode to normal mode. Check out the video and fix the SQL database suspect mode problem.
Suggested Courses

597 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question