Solved

trigger processing between remote servers

Posted on 2001-06-20
4
182 Views
Last Modified: 2008-02-20
I've created a trigger on a source server which interacts between 2 databases... Now I would like to move that second database onto a server farm which is accessible via an ip address...

Can I have a trigger interact between 2 different servers? and databases.... And somehow refer to the other server using an ip address

And if so, can someone provide me with an example (i.e.,syntax)...
0
Comment
Question by:adumas
4 Comments
 
LVL 6

Accepted Solution

by:
acampoma earned 50 total points
Comment Utility
you have to set up the server in your client configuration tool you can use ip address explicitly.
then you must set up your second server on your first server as a linked server.
then you explicitly reference the table by servername.databasename..tablename
0
 
LVL 2

Expert Comment

by:ZhongYu
Comment Utility
I would never try to implement a trigger between two servers, even if it is possible(?). The reason is performance. Trigger runs syncronously. I would use replication instead.  
0
 

Expert Comment

by:CleanupPing
Comment Utility
adumas:
This old question needs to be finalized -- accept an answer, split points, or get a refund.  For information on your options, please click here-> http:/help/closing.jsp#1
EXPERTS:
Post your closing recommendations!  No comment means you don't care.
0
 
LVL 3

Expert Comment

by:SQLMaster
Comment Utility
No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:
Accept acampoma's comment as answer.
Please leave any comments here within the next seven days.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!

Dheeraj Jain
EE Cleanup Volunteer
0

Featured Post

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

Join & Write a Comment

The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Via a live example, show how to shrink a transaction log file down to a reasonable size.

772 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now