updating tables in two servers

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • image77
    New Member
    • Sep 2007
    • 2
    #1

    updating tables in two servers

    how can i mirror a single table in server1 and server2 while getting the updates in real time?say tbl_plot is updating in server1 and also in server2 simultaneously? need help.
    Tags: None
    • debasisdas
      Recognized Expert Expert
      • Dec 2006
      • 8119
      #2
      As you have posted a question in the articles section, it is being moved to SQL Server forum

      MODERATOR.

        Comment

        • ck9663
          Recognized Expert Specialist
          • Jun 2007
          • 2878
          #3
          Originally posted by image77
          how can i mirror a single table in server1 and server2 while getting the updates in real time?say tbl_plot is updating in server1 and also in server2 simultaneously? need help.
          simple on? create trigger on tbl_plot to update the other two tables.

          a little complicated? REPLICATION...

            Comment

            • image77
              New Member
              • Sep 2007
              • 2
              #4
              Originally posted by ck9663
              simple on? create trigger on tbl_plot to update the other two tables.

              a little complicated? REPLICATION...

              im getting error on replication .can you give me the shortcut script for trigger?
              thanks

                Comment

                • ck9663
                  Recognized Expert Specialist
                  • Jun 2007
                  • 2878
                  #5
                  Originally posted by image77
                  im getting error on replication .can you give me the shortcut script for trigger?
                  thanks

                  check books online :D

                    Comment

                    Previous template Next
                    Working...