Replication

Huge Replication Scenario
Hello, We have several operational companies doing projects in the gas and oil industry. These companies use a smorgasbord of applications running against a central SQL Server in Central Europe. To overcome latency issues we are planning to have about a dozen SQL Servers all over the world and set up a bidire... 31 Jul 2008 10:18

SQL Server 2005 : define a transactional replication where delete instructions are not replicated
Thank you very much - it worked fine ! Hilary Cotter a �crit : Yes, basically you can replaced the command with a NONE statement. What may happen is that you need some deletes to replicate and then you will have to do the deletes on both sides. What most people do is do deletes through a proc and... 28 Jul 2008 05:53

Transaction Replication
Hello guys, I am using SQL2000, and want to set up the transaction replication. Is is ok to setup the simple mode on my publisher database? Thanks, Tomas ... 26 Jul 2008 08:55

SQL Server 2005 : define a transactional replication where delete instructions are not replicated
Yes, basically you can replaced the command with a NONE statement. What may happen is that you need some deletes to replicate and then you will have to do the deletes on both sides. What most people do is do deletes through a proc and then replicate the execution of the proc. On the subscriber this proc is a no... 24 Jul 2008 08:46

Guide for bakup/restore replicated DB
Hi, I have implemented a system with 2 SQL 2000 servers with a DB for archiving of production data of a manufacturing plant; the DB is merge replicated between the 2 servers. Now, the technical personnel of the plant has requested me a guide for the management of backup of DB and the restore of each machine in c... 24 Jul 2008 09:48

setting up Trans repl TO clustered servers
I am settign up transactional replication from a single 2005 instance to a clustered pair of 2005 sql servers. My question is do I set the connection to hit the clustered virtual name or the actual server names in the cluster? tia! ... 28 Jul 2008 05:53

Precomputed Partitions
We upgraded recently to SQL Server 2005 SP2 . For some issues we are having, we are looking at precomputed partitiions with our merge publication. When I run a sp_helpmergesubscription I see: keep_partition_changes = 1 use_partition_groups = 1 The system would have had to do these settings as we have... 30 Jul 2008 08:12

SQL Server 2005 : define a transactional replication where deleteinstructions are not replicated
Hello, Did anyone perform a transactional replication where delete instructions are not replicated ? Advises would be very appreciate. Regards ... 23 Jul 2008 12:16

SQL Server 2005 Start a transactional replication (push) usinga snapshot on a DVD
Thank's a lot. It worked fine. Regards. Hilary Cotter a �crit : use a pull subscription and in the alternate snapshot folder parameter for your agent, specify the dvd drive. note you will need to copy the entire directory structure from repldata down. On Jul 18, 4:53 am, Karine Lemoine <karine.lemo...@a... 23 Jul 2008 12:16

Missing owner specification in replication of schema changes
I have a problem with replicatin schema changes via ALTER TRIGGER. Wondering why they are transferred correctly, but not executed I found the problem in the exists clause which preceeds the statement. Here is the excerpt from the sysmergeschemachange of the subscriber: if object_id(N'[Trigger_Karteikarten_Ereig... 27 Aug 2008 11:31