Solved

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

Posted on 2011-02-23
2
171 Views
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.
0
Comment
Question by:SinghAmandeep
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 11

Expert Comment

by:rajvja
ID: 34967994
Hi

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

Accepted Solution

by:
Raja Jegan R earned 500 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.

http://support.microsoft.com/default.aspx?scid=kb;en-us;817064

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

Now try creating trigger which can help..
0

Featured Post

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
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.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

734 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