Results 1 to 5 of 5
  1. #1
    Join Date
    Dec 2006
    Posts
    5

    Unanswered: Triggering to another server

    Is it possible to set up a trigger on a table on one Sql Server that will trigger an event on another SQL Server on a different box? I have never done this before, so I was wondering if it is possible and how to go about it.

    Thank you

    Todd

  2. #2
    Join Date
    Mar 2005
    Location
    Netherlands
    Posts
    280
    You could try to use a linked server connection for this.

  3. #3
    Join Date
    May 2004
    Location
    Seattle
    Posts
    1,313
    I wouldn't recommend this.

    Triggers are supposed to be fast. do you really want your insert/update/delete to lock up the table while you go across the network to do a lookup?

    If the two databases are that intertwined, they ought to be on the same server.

  4. #4
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Could you elaborate more on what you are trying to do?

    So if I perform a dml operation on a table, you want some action to occur on another server

    What DML Operation are we talking about and what action are we talking about?

    You trying to build your own replication?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  5. #5
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Quote Originally Posted by tjmelcher10
    Is it possible to set up a trigger on a table on one Sql Server that will trigger an event on another SQL Server on a different box? I have never done this before, so I was wondering if it is possible and how to go about it.

    Thank you

    Todd
    Sure. Go to www.recipes.com and search for "Disaster".
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •