I created a 2PC transaction replication on a simple database for testing. Changes in the publisher are successfully replicated to the subscriber. However, when changes are made to the subscriber, the following error message is shown: "Another user has modified the contents of this table or...more >>

Transactional repl between 2 SQL server 2000 OS W2k3. We restored the databse from the 1st server to the 2nd server and then setup pull subscription from the new server to the old server which is the publisher. DB Name: ESI2, Tble Name: ESI2 In the pull subscription wizard i chose the opt...more >>

I created a pull subscription to pull information from a production database. When I started the subscription, the error "Could not find stored procedure 'sp_MSupd_tablename'" showed. I deleted the subscription in the subscriber and drop the distribution by running the "Disable Publishing ...more >>

Hi when I execute these statement.. sp_addsubscriber @subscriber = @@SERVERNAME It will gives Server: Msg 14040, Level 16, State 1, Procedure sp_addsubscriber, Line 95 The server '<ServerName>' is already a Subscriber. how can I check if the subscriber already exists or not thanks...more >>

Hi, This is me one more time.... now I am wondering about the impact of replication on the "auto filled" dates columns. For instance, some of my tables have a "Last Updated Date". Of course, now that I am going to use the system from Spain and from Florida that column will get the local tim...more >>

Thank you both for all your help. This board would be sorely lacking without the two of you. Hilary: Heres the deal. Your custom sync object was working, mine wasn't. @sync_method = N'character' That was the whole problem. I know you asked me to try this a while back and I did, but I...more >>

I've got a connection to a remote MSSQL 2000 box, Called "BOXA" via EnterpriseManager and the "sa" account. BOXA is currently set up as a distributor, as well as the destination for a PUSH replication from another box (BOXB). This replication works fine. I've set up a new publication on B...more >>

Hi, Please consider the following scenario Table A is an article in a publication on Server X. Server Y is a subscriber to this pubication. Server Y also can be a publisher for Table A and Server X can be a subscriber for the same. WHen i have a subscription on table A from server Y i c...more >>

Transactional Repl between 2 Sql 2000 servers with W2k3. One server is the distributor and the subscriber and the primary server is the publisher. When i 1st configured the replcation i had to manually start the Snapshot agent and the Log Reader agent to run, after doing so the replication wa...more >>

sql2k sp3 If you had more columns on Subscriber than Publisher, would you be more likely to use Clustered Indexed Views or Custom Sync Objects to implement 1 way, Transactional Replication? Pros and Cons for each? TIA, ChrisR...more >>

I have my replication setup, it should work fine with the exception of an error im getting while the supcription is trying to pull from the distibutor. Login failed for user 'CBB\services'. any ideas...more >>

I think Im missing a big part of sometihng here in regards to Custom Sync Object. (Subscriber has more columns than Publisher) I can make this work without a Custom Sync Object. It will work if I use a nosync approach, therefore not needing to BCP the snapshot to the Subscriber. Please rea...more >>

I'm running replication between databases on different instances on the same server. The subscription is set up to only run on command. When the agent is started, it runs until all queued transaction have been transfered then stops. This has been working fine for some time. It worked Mon...more >>

sql2k sp3 Howdy kids. Well by now you know the story as good as I do. The Subscriber has more columns than the Publisher. example: Publisher: [TransDate] [smalldatetime] NULL , Subscriber: [TransDate] [smalldatetime] NULL , [TransDateShort] [char] (10) COLLATE SQL_Latin1_Gener...more >>

I have a database with a large (and growing) transaction log. Running dbcc opentran yields the following two rows: REPL_DIST_OLD_LSN (0:0:0) REPL_NONDIST_OLD_LSN (508734:17171:1) A search through BOL and the news groups yields no information on the meaning of these values. The databas...more >>

Hello, Sorry for the long message! I have been trying to figure this out for a few days, reading BOL, reading newsgroups, reading MS's site, but I am still getting this error. I made a snapshot publication, and I am trying to make a new subscription, and on the page to Initialize Subscr...more >>

I have a hopefully easy question that I cannot find the answer to anywhere. I am attempting to automate the creation of an anonymous pull subscription. I have created the subscription on one machine, and then generated a script using Enterprise Manager to create the subscription. When I run ...more >>

Is it possible to continue on with the newer replication operations even when an error occurs ? I have set up transaction replication between two SQL servers. When an error occurs, all the subsequent changes to the database are not replicated, even if they might be error - free. Can this be do...more >>

Hi, I want to setup log shipping to a remote site for disaster recovery purpouses for a SQL 7 database. The question is how log shipping will intefere with my current backups on local site which I need to keep? I am doing a full db backup each night daily and one transaction log backup...more >>

We have setup merge replication on a production server/database that is also referenced by our web application. The replication works with a remote, disconnected application that uses MSDE as it's back-end. The replication works correctly, but we had to set aside a range of PKIDs for each tabl...more >>

Hi, I have just realized my snapshot replication is not including the default for the columns or the IDENTITY declaration of my columns. That makes my application fail, since I am snapshot-replicating some tables that are used for temporal processing (so i don't need merge). Does somebod...more >>

We have setup merge replication on a production server/database that is also used for our web applications. We need the replication for disconnected computing using an MSDE database. The replication works exceptionally well, however, we had to publish ID ranges on the tables so that data could...more >>

I have one table in Merge Replication with dynamic filtering and exchangetype=2 (from publisher to subscriber only), with Merge Agent scheduled daily (night) In this table I insert tipically some rows between two agent's run and I would like to replicate each row as single transaction (i.e....more >>

Hi, I am trying to perform database replication between the SQL and access databse. The SQL server is located at 192.168.0.1 and the access database is located at 192.168.0.11 After I have config the access db as subscribers and setting merge publication. When I perform push subscription...more >>

I'm trying to replicate a contacts table that has about 80000 records in it. When I set an identity range of 1000 but when the publication is created it keeps setting the next identity range to start at 49000. This creates an error that means that data cannot be entered either at the publi...more >>

I have been struggling for several days trying to setup bidirectional, transactional replication by Publishing the same table on each server with NOT FOR REPLICATION and an even/odd partitioning of the IDENTITY columns: CREATE TABLE test ( col1 INTEGER IDENTITY( 1, 2 ) NOT FOR REPLIC...more >>

Hi, I have a strange situation and I don't know what to do now. I have tried maybe everything there is to do :) Ok I have push, transaction replication between two servers. Sql agents run under the same domain user acc that is in Administrators both server (Win2k sp4, Sql 2000 SP3a on both serv...more >>

Is conflict resolution data stored somewhere? For example: If you resolve a conflict and choose not to have the logs mailed to you. Is there a way to go back and see what record it was that had the conflict? TIA Paul Bauer ...more >>

I am going to buy 2 new 4 way 64 bit boxes and i was wondering if they are going to be compatible for my current 32bit transactional replication. In other words they are going to become subscribers of my current replication. I read an article on microsoft that said that 64bit SQL Replicat...more >>

sql2k sp3 Howdy kids. So, now that management has made up they're minds(again, pulling my hair out now) Im back to part of where I was yesterday. At least since then though Ive learned a bit more about Replication and what will be required to make it work in my environment. Well you'v...more >>

I keep getting this when it tries to bulk copy a really large table. I am thinking maybe something happened when the snapshot was created or something to that effect. I am not the best at sql so go easy on me. tia -comb...more >>

I have a pretty standard log shipping arrangement created with the Log Shipping wizard against an existing database on the standby server. All the jobs were created successfully and run on the correct schedule. However, the copy job on the standby server doesn't work. It shows that it ran su...more >>

Greetings, Transactional Replication (Publisher SQL 2000 Enterprise Edition, Subscriber SQL 2000 Standard Edition)sporadically leaves incomplete transactions on subscriber's end with no errors reported. -SkipErrors Distribution Agent option is not in use. Any suggestion would be greatly a...more >>

Hi Guys I need to create an anonymous pull subscription over the Internet. I've got everything working but I don't want my subscribers to be able to connect to the publisher/distributor via Enterprise Manager or ISQLW or anything else for that matter!! Basically they should only be able to ...more >>

Hi All, My normal job that runs on the primary server that does the transaction log backup to the log shipping directory normally takes anywhere from 30 seconds to 5 minutes. However when doing a full backup the log shipping job and the full backup ran for 26 hours. Which normally runs...more >>

I'm getting the following error when I do a sync with SQL CE: Error Code: 80004005 Message : Run NativeErr.: 28557 Source : Microsoft SQL Server 2000 Windows CE Edition Err. Par. 0: data source=\Program Files\ThinkShare\Fdm\FdmJournal_eli.sdf; - Error Code: 80040E2F Message : The row update ...more >>

I setup trans replication to publish a table of approx 98 million rows. All seems to work fine. the snapshot runs completely, then I can see that the subscriber loads all 98 million rows. However once the import is done, it seems to stall, only leaving a message stating "The process is running a...more >>

sql2k sp3 Howdy kids. Im using Custom Sync Objects for Replication. The Subscriber has a different schema than the Publisher. (more columns) So I use sp_addarticle to create the article, @creation_script to create the table, and "before applying the snapshot, apply this script" to create ...more >>

I have two Solomon servers (one is active the other is a standby server). I would like to configure SQL replication of the Solomon DBs for disaster recovery purposes. It's absolutely necessary that any configuration changes do not cause problems with the active server. Has anyone successfu...more >>

Hi NG In a published db (transactional), anytime the option "trunc. log on chkpt."( for fast BCP) is active. I have set <PublicationDatabaseName>', 'sync with backup', 'true' <DisributionDatabaseName>', 'sync with backup', 'true' for full recovery in desaster case. Is it a problem? ...more >>

I have a merge publication using dynamic filters on an SQL2000 SP3a system. All subscribers are anonymous. Occasionally I have to perform mass updates on the underlying tables, which causes the merge tables (msmerge_contents, msmerge_tombstone, etc.) to grow dramatically. This in turn slows do...more >>

We are looking at testing out Replication of our large 3d models (approx 15GB of files number 300 000) between 2 x servers (dual P4 Dells) they are currently within same secure site on 1GB fibre backbone running Gbix cards) Our 3d Application is Solid Edge 15 with Insight. Our Server OS is Win...more >>

Hi all, I hope someone can throw some light on this one as I've been trawling for days and cannot resolve. We have a central server with 15 publications, each has a subscriber filtered on SiteID as each subscriber only needs to see it,s own data. We made some schema changes, adding new columns t...more >>

There is a bug in sp_MSget_load_hint, which causes a time out in the snapshot. It incorrectly tells replication to put obtain snapshot data in order by the first index. This would be fine unless you have a descending index. For our system with 30million plus records, it always timed out unl...more >>

Dear Recently,I want to do Replication in SQL.My purpose is made data in A SQL server as same as B SQL sever and two sever are updated to each other. Then, I choice choose "Transactional Replication". The below is my way to design it.(step) Publication->Transactional publication->"Immedi...more >>