Solved

trigger processing between remote servers

Posted on 2001-06-20
4
190 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
[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
4 Comments
 
LVL 6

Accepted Solution

by:
acampoma earned 50 total points
ID: 6211095
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
ID: 6214210
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
ID: 9282166
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
ID: 9513290
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

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
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 video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

717 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