Arthur Fuller
artful at rogers.com
Sun Feb 26 07:40:50 CST 2006
I've been a bit tardy replying to messages on this list due to work-load, but if you haven't already had a satisfactory answer, try using a trigger. You will have to reference the other database explicitly of course, using the standard dot notation: ServerName.DatabaseName.TableName. HTH, Arthur -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Paul Hartland Sent: January 31, 2006 7:07 AM To: dba-sqlserver at databaseadvisors.com Subject: [dba-SQLServer] SQL Server Database Replication Between Two Servers Importance: High To all, We have two servers (for the purpose of security lets call them SRV_1 and SRV_2) which both have a copy of SQL Server 2000 on them, onto which I have placed a test database (Dbase_Rep). When a user updates the database on SRV_1 I need the changes to also be made on SRV_2 either instantly or at a desired time interval. I know this can be done and have had a quick play and almost got it there. Does anyone have an idiot proof step by step guide starting from scratch or know where I can get one from. Thanks in advance for any help on this. PAUL HARTLAND