Hi chaps, I have generated a new publication and pushed the new subscription to the web server but when the snapshot is being applied I get the following error from the distribution agent. Insert Error: Column name or number of supplied values does not match table definition. Insert Erro...more >>

Hi chaps, I have generated a new publication and pushed the new subscription to the web server but when the snapshot is being applied I get the following error from the distribution agent. Insert Error: Column name or number of supplied values does not match table definition. Insert Erro...more >>

Since our outsourced database team made some changes to the database we are getting the following from the Distribution Agent Error Details: {call sp_MSget_repl_commands(5, ?, 0, 7500000)} Violation of PRIMARY KEY constraint 'PK__@snapshot_seqnos__7AB9340C'. Cannot insert duplicate key in ...more >>

SQL2000 20 tables in merge, 6 million records total in all. Let snapshot push data to new subscriber, snapshot and push of data to subscr was relatively quick (maybe 2 hours total) however metadata updates were taking 30+ hours. This was scrubbed. Plan B, restore pub database on subscr...more >>

I have all my tables in a db that have a timestamp (Rowversion) column used for optimistic concurrency checking. I know replication will convert this to a binary(8) field on the subscriber if the subscriber initializes itself with a snapshot, but what about no-sync initialization? I back...more >>

- What should the SQL permissions be for the Distribution db in a transaction replication with updating subscribers topology? Distributor/Publisher are on the same host. - sa ? - Can "guest" be removed safely? ...more >>

I'm trying to setup transaction replication between 2 servers. This is a one-way replication: Server A to Server B, not Server B to Server A. My snapshot publication keeps failing & I cannot determine why. I added commands to the agent so that it would create an output file, possibly with mor...more >>

I set you merge replication and it is working fine. The only thng that drives me nuts is that when I set up the passwords inside Windows Replication Manger in XP on a subcriber, it doesn't remember the passwords for the subscriber, publisher, or distributor from one session to the next. I d...more >>

Hi, I got the following message when after deleting the replication i tried to recreate that replication using the SQL scripts that i generated earlier the messages goes like this : Subscription : SERVER1:SvrTT cannot be reinitalized automatically because it was initalized manually when ...more >>

Hi , This is with regards to an earlier posting which i am still not able to resolve. Basically replication is on-going and working fine but certain updates were somehow not replication across. mine is a transactional replication. i have checked the followings : From Distributor/P...more >>

Took backup of pubdb & restored at subscriber. Merge agent now displaying 'Processing article tblCustomer' - along with 5 other large (1Mill+ records) tables. Then a series of 'Downloaded..100 updates..87 updates..68 updates.. Profiled subscriber, found -- exec sp_MSgetmetadatabatch -- e...more >>

Hi I am setting merge replication between 2 PCs in non-domain environment (2 PCs in the same wrokgroup) I have used SQL Authentication in both publisher and subscriber and even distributor by clicking Tools>>Replication>> Configuring Publishing,subscriber and distribution. Given them sam...more >>

Hello, I have SQL2005 server running on Win 2003 server. I would like to know if SQL2005 replication supports schema changes? Both SQL boxes are SQL2005, and I am looking at specific database (develop database on two different sites) to replicate from Server A to Server B (one way direction...more >>

SQL 2000. We have multiple million + row tables in merge. Just introduced new subscriber, metadata updates taking days (literally). Is it safe to manually move data from publisher db, and add merge subscription with @sync_type = 'none' ? Thanks, Chris...more >>

Good morning, i have a SQL 2000 with a Merge Replication on a server, i want to move the publisher (and the distributor) to another server, which has a diferent name. I can´t rename the new server, could run my replication on that server ? or when i attach the databases the replication fail...more >>

I'm trying to copy one table (233,883 records) from a 2000 box to a 2005 box. The wizard will go through and copy all the records across, but will hang on the last record and not proceed to the next step. What gives? ...more >>

The data changes that are made in the article at the Publisher are applied with deletes and inserts at the Subscribers, never updates. This happned only with one publisher . Others is normal! I see sp_MSdel first and sp_MSins after, but never see sp_MSupd stored procedure. This cause a lot...more >>

Is there any way to change the loopback detection flag without droping the subscription and adding it back via a script?? AHIA, Larry.... ...more >>

We have 2 databases with sql 2000 sp4 - running transaction replication between them in 1 direction. All during the day database A has transactions applied to it. The log reader picks them up and places them in the distributer every 15 minutes. The distribution agent runs just once at nig...more >>

I have an application that uses SQL Server 2000 and wants to use replication to allow two branches of a single company to share a database that is replicated locally (Say ServerA is on the East Coast and Server B is on the West Coast). The application is all transactional except for the rea...more >>

Hi, I setup the transactional replication of tables from SQL Server 2005 EE db to SQL Server 2000 (with SP3) db server. The publish db (EE 2005) and subscription db (EE 2000) located on different servers. The push agent not shows under Local Subscriptions folder in SSMS. Where can I view the ...more >>

Hi, I just setup a publisher using transactional replication and immediate subscribers in sql server 2000. When i try to update the table on the publisher it works fine, it gets replicated to the subscriber as expected but when i update a row on the subscriber i get an ansi_nulls error sayi...more >>

Hello... I posted this message back on March 23rd with no response...so I will try again. Recently, we have encountered the following error when replicating between SQL Server 2005 and SQL Mobile - "No key matching the described characteristics could be found within the current range."...more >>

Hi All, I'm hoping someone may be able to help me out. I'm a new SQL User, no one in the company has any experience with SQL. Running SQL Server 2000. We are running multiple databases on our SQL Server. I would like to create a test environment based on the existing databases. (Because I'm ...more >>

We are getting an error in the Application Event Viewer: An error occurred on line 127 while executing script 'SQL Server 2000 Replication Monitoring' Source: Microsoft OLE DB Provider for SQL Server Description: SELECT permission denied on object 'MSdistribution_history', database 'distribu...more >>

I am designing a SQL server 2000 / SQL CE (PDA) application that uses merge and RDA replication. There will be around 240 PDA's needing to synchronise across 120 depots. Will 1 SQL DB and server be sufficient to support this or will I need to have multiple databases and servers? ...more >>

Hello! I work in a Transactional Replication with queue udpate. I Create an article and add it to a publication with sp_addarticle. Then I execute exec sp_refreshsubscriptions 'publication' Add subscriptions to new articles in a pull subscription for all the existing Subscribers to t...more >>

We are running SQL Server 2000 Enterprise SP4 on 8 CPU server with transactional replication. Suddenly the SQL Server Error Log files are growing fast and now have grown to a few megabytes in size. There are lots of messages similar to these: Process ID 60:0 owns resources that are blocking...more >>

Function sequence error (Source: ODBC Driver Manager (ODBC); Error number: 0) The process could not make a generation at the 'Subscriber'. (Source: Merge Replication Provider (Agent); Error number: -2147200994) ---------------------------------------------------------------------...more >>

Hi I tried posting this query in microsoft.public.sqlserver.programming and comp.databases.ms-sqlserver but didn't get an answer I am new to replication but I am trying to setup up a transactional replication of tables from one database to another in MSSQL 2000 (SP2). (This is also happe...more >>

I've just started replicating tables from a publishing server to 4 different subscribing servers. (It's my first time doing this). I am getting some conflicting information regarding rebuilding indexes on a publishing database. If anyone can provide a good link regarding this subject I would ...more >>

I have setup a transactional replication from oracle to MSSQL2005. One of the publication includes 26 articles but I found that there are only 24 articles replicated to the subscriber DB. I found that the repldata folder includes only files for 24 articles only after generated a snapshot. ...more >>

Hi: I am using transactional replication. I cannot see some transactions in subscription database. Replication monitor does not show any error. All the agents (log reader and distribution) are running successfully. Is this a latency issue? I don't have this problem with some of the oth...more >>

We seem to have a "problem" database. The database is hit by processing (inserts, updates, selects) done by a compiler app; selects, updates and insert through the web by clients, queries by customer service reps, as well as report parsing and a couple of other apps running against it. The ...more >>

On a failover MSCS cluster with currently several SP3 virtual servers/named instances, we plan on adding a new virtual server/named instance and apply SP4 to it. On the same cluster, there is an SP3 virtual server/named instance in a replication topology based on transactional replication with ...more >>

Hi, I setup the transactional replication for our pre-production database in EE 2000 (SP4) Cluster server. I got error message from log reader as following: Error message: The process could not execute 'sp_replcmds' on servername. Error details: The specified begin LSN (0000680a:0000273...more >>

Hello, I'm trying to figure out if Oracle Replication is indeed only available in the Enterprise version. From reading the online books, it appears that my standard installation has the nessessary scripts to create a oracle publisher, but according to the microsoft page where they compare the...more >>

Using MSDE a number of my published tables have 2 identical indices both on the ROWGUID column. One of them uses my naming convention and the other is an auto-generated one named 'index_nnnnnnnnn'. I believe that my index existed prior to replication being created. Is it safe to delete the a...more >>

Hi I sometimes have subscriber database in a transactional replication down due to scheduled maintenance or network outage. Once distributor can't connect 10 times to subscriber - it shows errors and only way is to re-initialize publication. It's expensive and time consuming. I would be looki...more >>

This is my first time setting up replication and i used the following tutorial: http://msdn2.microsoft.com/en-us/library/ms171908.aspx I went through the tutorial a few times getting the same error msg. I uninstalled and reinstalled my environment: - xp pro w/ sp2 - sql server 2005 - vis...more >>

Here's a new error from sql 2005 i'm not sure how to handle this...? any run across this.... not all subscribers are getting this... & this has not fixed itself: Error messages: The merge process could not access row data at the 'Subscriber'. When troubleshooting, restart the synchro...more >>

I will be implementing replication for the first time. I plan to use a push subscription to a web server. The database tables to be replicated will have less than 100 transactions per day (some days there may be none and the average will probably be less than 20/day). Data will only change...more >>

I am encountering an issue where, with several different replications occurring, the agent jobs start but never really seem to do anything with the second job step. They say they are running, but they don't do anything. Restarting SQL Agent causes them to work, but then other replications ...more >>

I setup replication with SQL2000 publisher going to SQL2005 subscriber. Distributor is on SQL2005 server. After initially setting this up the SQL2005 server was repurposed and now I have a new SQL2005 server (different servername) to use. Now when I try to configure SQL2000 replication from...more >>