SQL Server stored procedure to update two databases on differrent servers

The two servers have exactly the same setup (databases/tables etc). I want one of the tables (on both servers) to have the same data. So the update procedure on server A should also be able to update server B.

I want this to happen with each call to that update stored procedure with out any time delay. Any thoughts?

  • sql server sum column to find out who reached a value first
  • How to handle a nullable foreign key field in Entity Framework?
  • How to merge when each row on table A needs multiple rows from table B in SQL Server
  • How do you copy a record in a SQL table but swap out the unique id of the new row?
  • SQL sp_executesql makes strange complaints
  • BizTalk SQL Generate MetaData Failure
  • I did look at the other questions but this aspect of multiple servers seems to be un-answered. Any thoughts?

    Edit to clarify: The Server B always should follow Server A. (Also, the stored procedure that updates A can be edited to update B… if the Dbs were on the same server… this is a different case.)

  • Getting a Dynamically-Generated Pivot-Table into a Temp Table
  • How should i work in this scenario . Should I use Trigger or Leave on User to manage
  • How to fetch entries starting with the given string from a SQL Server database?
  • Changing SQL Server collation to case insensitive from case sensitive?
  • Best practices for database development in Visual Studio 2010?
  • how to separate string into different columns?
  • One Solution collect form web for “SQL Server stored procedure to update two databases on differrent servers”

    Take a look at SQL Server High Availability solutions. Log Shipping, Failover Cluster, or Database Mirroring may fit your particular needs. It depends whether you need a failover for backup or an online DB for reporting.

    Side Note: Database Mirroring will be deprecated in future SQL Server versions and should be avoided. It is being superseded by AlwaysOn Availability Groups in SQL Server 2012.

    MS SQL Server is a Microsoft SQL Database product, include sql server standard, sql server management studio, sql server express and so on.