I have 2 tables which tab B depends on the record on tab A. In publisher, records are generated to tabA before some audit information record to tabB. In subscriber, there is replication error that the trigger in tab B couldn't find the corresponding record in tab A and cause the transactiona...more >>

Hello, I've got a simple transactional replication set up. I have a separate publisher, distributor, and subscriber with 76 articles (tables only) being pushed from the distributor. I have this exact setup with the same tables and data working in the SQL 2000 environment. I am testing ...more >>

I am going to create snapshot replication which will be scheduled to run once in a month. my question is about as there are 10 users in my publisher database, how i can create those 10 users in Subscribers. i know there are options like i can create manually but i don't want to take that route...more >>

We are using SQl 2K with sp4, and using push transaction replication. Recently we need to add a new field into an existing primary key where it belongs to a published table. What is the quickest way for me to replicate the new primary key over without reloading the data since the table is qu...more >>

Does the merge snapshot agent really need to take a snapshot every 24 hours? I just discovered this, I have some really large tables in merge and am noticing contention/blocking at the pub each night at midnight... Can i have it safely do this once per week? Does it really need to be 1 / ...more >>

Hi, In a particular scenario, the customer has a Win XP with SQL Server 2000 Personal Edition. I want to establish replication environment. Obviously Merge and Snapshot replication is available. Snapshot is not suitable, the only option is Merge. Some tables must not reflect the changes to pu...more >>

Hi, I have the following issue : my replication is txn , immediate updating This is an existing replication and i am changing one of the acct ABC123's details via the Application. From the Replication i could see that it says "1 transaction with 3 command were delivered" However, when i ...more >>

Hi, One application is running in two different locations. The database structure is the same for both. Each database has its own data. For replication, I cannot apply snapshot of one to the other because the target will loose its data. I was thinking of exporting their data to an intermedi...more >>

We use SQL Server 2000 with merge replication with 500 users. We are moving the server and need to temporarily move the database to a different server while the server is moved. Is there a way to backup and restore the server (publisher) without having to create a new replica set? Any refer...more >>

Hi, I am trying to copy a Subscription db so that I can install it at a remote site (large file) but am unable do so. I am using SQL Server 2000 and the remote site uses MSDE 2000. The Publication properties --> Subscription Options tab has the option for 'Allow new subscriptions to be c...more >>

----------------------------------- SQLCE (Server Tools) will not install without SP1 it will not install with SP3. You must install SQL2k -> SQL2KSP1 --> SQLCE --> SQL2KSP3 SQL Replication will not work if the SQL service is running under the system account. You MUST configure the SQL service...more >>

Hello everyone, During our nightly replication we replicate a table SERV from a third party. This table contains codes for all open and closed orders from the past 2 years. It is around 3 - 3.5 GB of total data. The console starts the first attempt around 2145 - 2130 and the table runs until...more >>

What do I need to do to replication in order to keep the merge tables (MSMerge_contents, MSMerge_genhistory etc) as small as possible? How significant is the subscription expiry to the size of the merge tables? The merge cleanup job is run every day. The subscription is set to expire after 8...more >>

I need you help to have a best practice that i can use to bring in effect.In my SQL Server 2000 i have database name XYZ (Production Database) & i have created another Database on same server as XYZ_Monthly. As per Reporting requirement at the last day of every month i have to backup XYZ Prod...more >>

Given that , apparently SQL Server 2000 replication will not support full-text indexing does anyone have any good workarounds or method suggestions to accomplish a reasonably up to date copy on a secondary server ? Any advice greatly apprecaited. steve...more >>

Hi , I would want my replication alert to write a log into the Event view , how can i do that ? i looked thru the Replication Alert properties but dun seem to be able to find some method how can i actually do that ? and if codings are required how shld it be written appreciate any ad...more >>

Hi !!! I wanted to know how to create replication in SQL server 2000...more >>

Dear Sir/Madam, I have a replicated database which all data and log file are currently on RAID 5, and I now would like to move the log file to another drive which is in RAID10. As I can't detach the database for relocate the log file, what option do I have to relocate the log file but no nee...more >>

The log file on the Subscriber database keeps growing. The Subscriber is on Sql 7. Will setting the recovery option to "Truncate on Checkpoint" affect the process at all. Thanks KR ...more >>

Hi. I have a server called serverA that is publishing a table called test_replication. Server B subscribes to this table. When a record is directly inserted on serverA.test_replication, the record is transferred over to serverB.test_replication successfully. This is also true for the vic...more >>

my tables have foruignkey constraints and these tables have to replicated. there are several number of tables and i created only limited number of publication. If i have many articles in a publication can i specify the order by which these tables must synchronize -- thanks, ----...more >>

I have just implemented merge replication with one subscriber. I have a "SLI" table that has an identity column in it. When I set up replication, I configured the identity range management as follows: Range size at Publisher: 10000 Range size at Subscriber: 10000 Assign a new range %....more >>

Hi. I have a problem in Data replication. teh Synchronization stops after a period of time I ahve the following message: "value cannot be null. Parameter name: Strobjectname" in the replication monitor Any hint? ...more >>

Hello all.. We have merge replication running on devices that have SQL Mobile and our server is SQL 2005. We seem to get alot of replication errors that require a reinitialization of the publications. With SQL 2000 and SQL CE....we had very few of these types of errors. I saw that SP1 ...more >>

Background: - We will be using Merge Replication - Our subscribers will be offline while entering data and will go online via the internet to sync. - We will be supporting a very large subscriber base (2 – 5 thousand subscribers) - Our current topology is a Centralized Publisher and Dist...more >>

Hello, I have an application to synchronize data between the MS CRM and and an external ski reservation system. When i push data into the ski reservation system via a bulk xml, datas are imported in a database A which is later replicated on the main database B. The problem for me is that on...more >>

We've set up a merge replication (sql server 2000) at a customer's place. Recently, there had been some updates on the db design we had to deal with. We've made a backup of the publisher db but forgot to check conflicts first. Then we built down the replication, updated the db design and built ...more >>

HI, I'm currently playing with snapshot replication between two 2k sql boxes. When the database is pushed to the subscriber the publication is applied it is possible to query the database between the data being dropped and being replaced. Is it possible to have this process enclosed in a t...more >>

Hello, I've been trying to tackle a problem all day, and I can't seem to find a reason or solution to my problem. I've been trying to set up replication between our production SQL Server (2000 sp4) and our development SQL Server (also 2000 SP4). The plan is to use a Snapshot replication ...more >>

Hi, Since I don't know which group would be a right newsgroup to post for this problem and most likely that it would be involved with expertise coming from residents of different newsgroups, hope multiple-group posting is ok. Solving this problem means a lot to me and my team. Thank you v...more >>

Any one know of or have any SQL scripts that will compair 2 tables?? I have searched & searched and have not found any that will work. I am downloading Red-Gate, though I was looking for a script. Larry.... ...more >>

Hi All, Apologies if this seems silly, only I'm not so good on the transaction log side of SQL. I've got a subscriber set up with merge replication to a publisher (SQL 2000). When the database was set it up defaulted to full recovery model (I hope to change this soon). As far as I know, ...more >>

Recently, all of my SQL 2000 Servers O/S were upgraded (new install) to Win 2003. Ever since, I am having a couple of problems with most of the subscriptions. The first is.... 'Another distribution agent for the subscription(s) is running.' I have researched this error/message and have...more >>

Hi, We are looking at maintaining Transactional data across 6 to 7 countries in Asia, including those with weak internet connectivities, and replicate them to a single Database in one of the countries, over Internet. Is SQL Replication a good candidate for such solution ? Can Replication ...more >>

Suddenly we encountered an error while running a scheduled snapshot agent of the merge replication. this is the log: Microsoft SQL Server Snapshot Agent 8.00.760 Copyright (c) 2000 Microsoft Corporation Microsoft SQL Server Replication Agent: SQLBB-ReservasiBigBird-ReservasiBigBird-1 Co...more >>

L.S. I am trying to set up replication using SQL Server 2005. I do not want to use the standard port number 1433, so I changed it. I created an alias for easier use as well. But when I try to create a subscription to that server I am not allowed to specify anything else than the real server...more >>

I restored a production DB that was a Publisher on a non-Replication ready Server. When done I had hundreds of conflict talbes, vews, stored procedures and no desire to take hours to delete the neat 1000 objects manualy in Query Analyzer. The stored procudure to clean replication objects did...more >>