Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

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

Posted on 2011-02-23
2
Medium Priority
?
186 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
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 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.

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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an anti-spam), the admin…
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…

578 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