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

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 194
  • Last Modified:

trigger processing between remote servers

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
adumas
Asked:
adumas
1 Solution
 
acampomaCommented:
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
 
ZhongYuCommented:
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
 
CleanupPingCommented:
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
 
SQLMasterCommented:
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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

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.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now