Solved

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

Posted on 2011-02-23
2
150 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 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

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

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

Suggested Solutions

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…
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …

770 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