| Thread | Last Post | Replies |
|
| Sql Server 7.0 sp_repladdcolumn | 28 Feb 2007 22:28 GMT | 1 |
Does sql server 7.0 support @force_invalidate_snapshot parameter?
|
| Replication with identity key failing | 28 Feb 2007 15:50 GMT | 5 |
I have a transactional replication setup. The table has an identity key (SID) which is set as a unique key with no replication. However when i try to run the distrinution agent i get error 8102 "Cannot update identity column ESID
|
| Merge Replication and Multiple Record UPDATE statements | 28 Feb 2007 14:33 GMT | 2 |
We have a database in which global updates must be periodically made to multiple records, usually in the hundreds or thousands. Is this a problem when using Merge replication? Because there are individual merge triggers on each table, is it preferable to use a cursor to make ...
|
| Error: Syntax error or access violation | 28 Feb 2007 03:14 GMT | 15 |
In my replication, I noticed the following error. Can you guide me to the right direction to troubleshoot this. In the Last command section: {CALL sp_MSins_GCFD$Sales Header (0x0000000001b52c48, 1, 'ORD211801', '',
|
| max text repl size: Which Server(s)? | 27 Feb 2007 23:53 GMT | 2 |
For a publication we have, I need to increase the value for "max text repl size". On which servers in my replication topology do I need to set this option? The publisher, distributer, and/or subscriber?
|
| Replication over the internet problems | 27 Feb 2007 22:44 GMT | 6 |
I have a situation where a customer has a SQL 2000 database at thier office location, this is where they do data updates, it replicates to a SQL 2000 server located at a web hosting facility. Problem is there is a new IT guy at the office location that has done something to the ...
|
| Transactional replication into existing (non dbo) tables | 27 Feb 2007 19:39 GMT | 1 |
I am trying to setup a transactioal replication from 2 servers to 2. I already have a table that has an owner that is not dbo (lets say user1) Whenever i setup the replication if i tell it to create schema and data, it create dbo.table on the detsination. If i chose to not create ...
|
| Merge Replication between MSDE2000 and SQL 2005 | 27 Feb 2007 14:18 GMT | 4 |
Hi, I want to ask about SQL Merge replication between 40 MSDE2000 as Publishers and SQL 2005 as Subscriber. I received an error message while configuring the replication saying "For Merge publications, The version of the subscriber must not exceed the version
|
| Merge Repl: Adding existing column | 27 Feb 2007 13:00 GMT | 2 |
Hi Guys; What proc would I use to add an existing column to an existing merge publication? I realize that an entire reinitialization will have to take place :(
|
| Queued updatable subscriber... | 26 Feb 2007 19:58 GMT | 1 |
can someone explain the proper usage of a queued updatable subscriber in a transactional replication scheme? in other words, what are the ways in which you can tell the subscriber to empty the queue of outstanding transactions that are to be applied back at the publisher (keep in ...
|
| multi-master 'merge' replication | 26 Feb 2007 16:58 GMT | 5 |
SQL Live-Live – what are the options for the DB clusters to be in an ACTIVE/ACTIVE configuration with multi-master “merge” replication? What is the network requirements, what about data integrity, latency, performance? Basically I am trying to design a new SQL Database ...
|
| Backup publisher DB | 26 Feb 2007 16:51 GMT | 3 |
Can I make a backup of my Publisher DB and then restore it on the Subscriber, or this operation can generate problems?
|
| General SQL Server 2005 transactional replication question | 26 Feb 2007 09:46 GMT | 20 |
I want to implement transactional replication for failover purposes. I need to replicate data from a primary database to a secondary one that will be used if the primary goes down. In the event of a primary failure I need to switch the applications to run off the secondary. When ...
|
| Conflict resolution for Transactional Replication with Updating Subscribers | 26 Feb 2007 07:46 GMT | 2 |
I'm trying to establish whether Transactional Replication with Updating Subscribers meets my requirements. I have chosen to use "publisher wins" for the conflict resolution. (I'm using SqlServer 2005 Developer Edition on Win XP SP2 on both machines)
|
| Inserting new records from multiple mobile users | 26 Feb 2007 00:25 GMT | 3 |
When using merge replication and all subscribers use the same subscription and when two or more subscribers insert new records, does replication on the server automatically modify the unique ID field for that record. In other words, if mobile user A inserts a record and the
|