Using one of the default resolvers - 'Subscriber Always Wins', is it normal that resoved conflicts still appear in conflict viewer, or is their another stage to the process I'm missing. ...more >>

Hi, could you give me an step-by-step example how to do replication between MSDE2000's ? I have 50 tables, each table has an ID GUID primary key column. thanks. ...more >>

I thought I could force data to be sent on the next merge by doing a simple update statement on the rows I need sent. Ran update statement at the subscriber Update MyTable SET A_Column = A_Column This doesn't seem to work for rows that don't already exist on the publisher. Is there a sy...more >>

Hi, Currently we have a problem regarding security for replication. We have a SQLServer that hosts about 30 databases. One of the database owner requests that he needs to setup replication. But I don't want him to give full 'system admin' rights to setup replication as he might mess up...more >>

I am trying to copy the MSSQL7 Database from one Server to Another. On Server "A", the MSSQL7/Data Directory is on the "D:" Partition. On Server "B", the MSSQL7/Data Direcotry is on the "E:" Partition. I have copied the entire Data directory from Server "A" to Server "B". Now when I try ...more >>

Hope someone can help with this. I've implemented merge replication and when I make an update to the server that acts as the distributor the update is reflected on the subscribers. However when I make a change on the subscriber I cannot see it on the other subscribers or on the distributor. An...more >>

Here are the logs from this error.. This is a 8gb table i am trying to replicate across a wan. It usually gets about 1/2 done and then just craps out and starts over. Our connection is very stable and so is the subsribers. I cannot figure out why i get this.. Table "dpvHstGndItem": ...more >>

sql2k sp3 From what I know the only problem with checking the "Do not lock tables duing snapshot..." would be that the snapshot would take longer. Are there any other downfalls? ...more >>

Hi, We have a merge replication. The publisher pushes to the subscriber. For one table however, we need to replication to be one-way only (from publisher to subscriber) - how can we achieve this? Thanks -- Pete Griffiths Idonix Ltd ...more >>

I replicate data from SQLServer 2000 to Oracle 9.2 But Oracle does not understand nonclustered index . Here an exemple - from idx script. ALTER TABLE [t_Niveaux] ADD CONSTRAINT [PK_t_Niveaux] PRIMARY KEY NONCLUSTERED ( [Niv_Id] ) WITH FILLFACTOR = 90 How to avoid that ? Thanks fo...more >>

I suppose I don't understand this command well. I read books online, = but still cannot grasp why my Distribution database on the Publisher = returns over 300,000 rows when I execute the command. Do I not have = something set correctly? A cleanup Distribution database job is scheduled to run...more >>

Hello, I need to replicate tables from SQLServer 2000 to Oracle 9.2 Using MDAC 2.8 & Oracle ODBC driver - 1-An index on 2 columns for a table exists but when it is created on oracle only first column is used. The idx script contains right declaration : CREATE UNIQUE INDEX [pk_nivprev] ON ...more >>

Hello All We have a computer based application running on trucks and they capture the transaction into a Access database we need to collect the data from multiple trucks into a SQL Server database centrally. Can somebody please explain whether Access can replicate to SQL Server with Access ...more >>

I want to do some kind of replication for backup purposes. I know you are limited in what you can do with the standard 2000 sql. What kind of replications can I do and how do I set them up. I was thinking about log shipping....more >>

Hi, There is a undocumented Merge Agent parameter (-ForceConvergenceLevel) that could solve some of my troubles, but where do I specify it? It's not available in the the profile setup for the agent in the Enterprise manager. It's possible to specify it on the command line to replmerg.exe, b...more >>

My merge replication was working perfectly fine on SQL 7.When i upgraded to SQL 2000 it is givng problem.I simply took back and then restore it SQL 2000.Now merging of data is proper but when i am acessing my data in my software then it is giving error with some long error no. Please let me k...more >>

Hi, I'm having periodic problems with some SQL CE subscribers that dosen't get all data replicated. When synchronizing a common, non filtered transactions table/article all subribers should be able to see tranactions from each other. Somehow one or two of 40+ subscriberes don't get all row...more >>

Hi - I was wondering how one goes about getting infomation on agent activity (merge and snapshot agent in my case). I would like to know when the last synchronization took place, if it failed or not, any error messages, etc. How can I get this information without EM? Thank yo...more >>

I think I'm looking for replications, correct me if I'm wrong. My goal: Keep a local copy of the database(s) on my SQL Server 2000 at the data center, and minimize the amount of transfer bytes by only updating what has changed since last transfer. The purpose of this is to have a backup. OK,...more >>

Hello all, I have a merge publication on one end of a slow WAN link and a subscription to said publication on the other end of the aforementioned slow WAN link. Recently, the link decided to take a vacation for a week or two and was (for all intents and purposes) inoperable. Upon finally fixin...more >>

We have a server that is replicating information back and forth to 10 different location. My question is how do i know if a location is done replicating to us. my scenario is that we have 10 stores, each stores as it makes a sales, the information is replicated back to corporate. Corporate ...more >>

First off I have... A) I have a database with no primary keys .. B) I have two machines setup with SQL 2000 Advanced.. C) One with my data on it running in production right now.... D) An app which uses ODBC to connect.. What are my options and my best route for redundancy and high availabil...more >>

I am trying to write c# code to automatically setup a configuration. I am given a database and a list of articles in the database to publish. The Generate Sql script function generats some sql which is what i based my c# program on. I used sql-dmo to generate TSQL statments to be executed via ...more >>

Hi , I have an stronge problem with my merge replication. When i make change in publisher , is replicated immediatly to subscriber but when i make change in subscriber , is not replicated to publisher and the changes in subscriber is rollback. i think the problem is in the FK's or the ...more >>

I am adding a new article to my merge application with @force_invalidate_snapshot=1 so I wanted to manually restart the snapshot. I am executing the following script immediately after I add the article: use master go exec xp_cmdshell '"c:\Program Files\Microsoft SQL Server\80\Com\snap...more >>

Can someone point me to an article explaining this or deny that replication uses tempdb? I see 3 replication-related tables in there but the data seems to be relatively-static. I'm looking more for something that would use a lot of the log file for tempdb. My reason for asking is that our temp...more >>

Since merge replication does not guarantee Transactional integrity, how is data integrity acheived? How does it work in this simple scenario? P-Table F-Table 1. Subscriber edits a given row in ptable and the associated rows in ftable. 2. Publisher edits the same row and doesnt modify ...more >>

How can we limit the number of anonymous merge subscribtions to a given publication? Can we limit it by machine MAC address?...more >>

I have replication setup for our databases between 3 different sites. It is using MERGE replication, continuously updating. Most table I am replicating, but some I am not as they are temporary tables that the data doesn't need to go to the other sites. Now I need to change one table so that th...more >>

Can I set it to send email notification when conflict occurs in any of the publications?...more >>

I am testing a scenario with merge replication when publisher has an entry 1st, and the same data entered into the subscriber later (but before merge agent runs). I am using merge replication with 'Microsoft SQL Server DATETIME (Later Wins) Conflict Resolver'. I inserted the same row (row wit...more >>

There are two sqlservers. One of them is the primary database, which is running a job, which retrieves data from some other databases and stores them. The other one is the secondary database, which is supposed to be used when the primary database doesn't work. I believe that I can synch t...more >>

The Distributor is not available Error 18483 coult not connect to server "VNSV20009' because 'distributor_admin' is not defined as a remote login at the server. Here is the scenario. We have 1 SQL server that replicates to another local reporting server, and a server on the internet. They ...more >>

SQL Server Enterprise Manager encountered errors creating push subscriptions for the following Subscribers: JANUS: Error 208: Invalid object name 'sysextendedarticlesview'. The error above shows up each time that I attempt to push the subscription. THe view sysextendedarticlesview exist in ...more >>

I am running SQL Server 2000 w/SP3a on my publisher/distribution server. I have merge replication setup with 6 subscribers. The subscribers currently (in the process of upgrading) are all running SQL Server 2000 MSDE w/no service packs. The MSDE machines move in and out of replication (they...more >>

Hello, I have set up a merge replicated database that uses FTP to retrieve the initial snapshot. I'm using SQL Server 2000 as the server and MSDE as the client. Several of the *.sch files are transferred correctly, but then the connection hangs. Looking in the IIS FTP log, I see the followi...more >>

Hello a transactional replication with immediate update is successfully built between SQL 2000 Server Ent. Ed. with SP3 in the Asia and another SQL 2000 server Ent. Ed with SP3 too in USA, Asia server is the distributor/publisher and USA server is the subscriber server, transactions from the p...more >>

I need to increase the size of a column in a table which is part of merge replication. Here's the approach I believe I need to take: 1) Use sp_repladdcolumn to create a new temporary column and use the schema_script to populate my new column with the values from my old column. 2) Use sp_...more >>

I have SQL 2000 Enterprise edition on my production server, and SQL 2000 Standard on another server that will be used for my standby server. Can I use Log Shipping in this case? I read I must have enterprise edition, but do I need it on both servers? Mike ...more >>

Our current topology uses two distinct sites connected by a somewhat erratic T1 line connecting an Access replicated database. The data sets must be identical (excepting the latency effect between synchronizations which is acceptable). The database effectively tracks employee movements - data ...more >>

Hello, Thanks for ur solution in replication problem. Please can you urgently help us in this problem. Thanks in advance. We have implemented the Merge replication for our online/offline scenario. We are using Pull Subscriptions and trigerring the SQL Merge Agent and performing synchronizat...more >>

First off, I'm a bit new to replication so bear with me... I have a merge replication set up and that works just fine. However, on one of my tables (call it TableA) I have an Update trigger in addition to the Update trigger that gets created as a result of replication. This trigger inserts a...more >>

This is the log shipping scenario I wish to setup. I would like to have a series of half hourly log backups copied over to standby server as soon as the backup is done and have them pile up on the standby server, loading the series of them every 4 hours. However; from what I gather from avai...more >>

Dear All, From the online book, SQL Server only monitor INSERT, UPDATE, DELETE statment If I modify the data through Enterprise Manager directly. Does that data will also published to other Subscriber? Thanks~ ...more >>

Hello, I have a couple of questions with respect to conflicts. We are in the process of testing whether replication will work for us. We have about 60 mobile computers that use access right now and data is transfered via a vb.net app. We are planning on getting rid of the vb.net app and...more >>

I know that there have several replication option one of it was Updatable Subscribtion It includes 3 options one of it was queued updating, I would like to know if Publisher not accept the changes, what will occurs on Subscriber? rollback to not update status? Thanks~ ...more >>

Hello all, As far as I can see, merge replication is exactly the same as transactional replication with queued updates. What's the difference? SQL Server Books Online just says to use Merge if updates are carried on a permanent basis, but it doesn't say what the concrete difference is. I ne...more >>

The Log Reader Agent has failed again with the error "Could not execute sp_repldone/sp_replcounters.." and we are unable to restart the agent. MSrepl_transactions table holds two entries on the Distribution database one dated 9-24 and the other 10-10, and the xact_id is not the same as the one...more >>

Hello there I have database that i marked it before as publisher. Since then it showed with hand near to it. And then i can't detach it. I remove the publisher and it didn't help What should i do for detach it now? any help would be useful ...more >>

I am looking for a way to increase the size of a varchar field in a replicated database, without disturbing the data of course. I do not want to remove the replication just for this one issue. What would the process be in writing a SQL query to accomplish this? The table name is tblBid, and...more >>

Hello: If merge replication uses anonymous pull subscriptions and the subscribers have no sql server tools installed, how can the subscribers resolve conflicts? (Can we provide a program interface to help do this?) Does replication(merge) preserve transactional integrity whil...more >>

Hilary Cotter mentioned to someone to reapply SP3A to fix the problem. I have a really stupid question. Which device are you reapplying SP3A? (The distributor, publisher, and or clients?) Thanks, Amy M...more >>

Hello, I am creating Publication through sql script. I have created Publication on my machine using wizard and after that I created the script for the publication. When I am running this script on another sql server it is giving me an error saying Distributor not configured properly. What I n...more >>

I have selected 34 articles for replication, but when I run the snapshot agent it says that 31 articles have been generated. We have 31 tables as part of replication, but we add and remove 3 additional tables daily for a total of 34. Also, when view the properties of the publication and select...more >>

Dear Experts, Would you please help me to set SQL 2000 replication ? I need a link or article that show me how to set replication between SQL 2000 servers. thank you best regards....more >>

Hello a transactional replication with immediate update is successfully built between SQL 2000 Server Ent. Ed. with SP3 in the Asia and another SQL 2000 server Ent. Ed with SP3 too in USA, Asia server is the distributer/publisher and USA server is the subscriber server, transactions from th...more >>

I have Merge Publication with SQL Standard Edition publisher and MSDE subscribers. Due to database size (1,8 GB) I'm preparing to upgrade SQL Server subscribers from MSDE SP3a to Standard Edition. Can I do this without breaking the subscription (i.e. simple upgrade), or I have to unsubscrib...more >>

I have two sql2000 servers P (publisher) and S (subscriber). S uses anonymous pull merge subscription. Data on S was edited. When I wanted to start synchronization, some error occured. I made backup on S, dropped the subscription and recreated the subscription with new snapshot. From Enterpr...more >>

Is there an easy way to make changes to a publication using procedures like sp_repladdcolumn and sp_changemergefilter with @force_reinit_subscription set to true but also force the reinit to be a reinit with upload? For sp_changemergefilter I rewrote the procedure to force upload and am curre...more >>

Hello, We have 9 SQL 2000/MSDE (mostly SP3) servers as subscribers and one SQL 2000 SP3 Server publisher (on Windows Server 2003). Merge replication worked well for some months but today we noticed strange behaviour: - Subscriber A (MSDE 2000, SP3, Windows NT Server 4.0 with SP6a) have made 1 ...more >>

I have several tables replicating to an Access database. I'm using snapshot replication, and some transformations are running for the publications. Most of the push subscriptions are set to continuous update. My problem (actually there are several, but I will stick to one at a time) is that ov...more >>

I have merge repl setup and it has been running with no problem... until a scheduled task that runs once every night and updates a very large amount of records was introduced. Merge repl is scheduled to run every hour. Now the merge attempt directly following the nightly task that updates a larg...more >>

I attempted to restore a database from backup (the same way I've done for months in the past), but this time I got an error, and the database is marked as LOADING and is not accessible. Help! We have about 2 gigs free on the server, and our largest backup file/log is 211 mb. How do I ge...more >>

hi, we have a BD that use a triggers for Referential integrity, no with Foreign keys, and i will do a merge replication, the replication do not recognize what a table will be change in first. Please help for create FK with this triggers. thank's....more >>

Hi all, i found a column "msrepl_synctran_ts" have been added to one of my replicated tables but not found in other replicated tables. I guess this field may be added by the DB server, i would like to ask under what situation or configuration this field will be added and the field is timestam...more >>

Any links to resources about Merge replication which allows subscribers to update data would be greatly appreaciated. Thanks, AR...more >>

We are getting a reoccurring log reader failure with our transactional replication. The error does not seem to be recoverable and we have to drop and recreate the publication/subscriptions whenever it happens. Error text: "The Process could not execute 'sp_replcmds' on '[servername]'. Repli...more >>

I'm beginning testing on a Replicated database with Log Shipping. Which technology should be configured first? Or is there any particular order? I haven't seen anything addressing this anywhere yet. SQLServer 2000 Enterprise with SP3 on all servers Publisher and Distributor on the same serve...more >>

I have a quick question that I could not find the answer for anywhere. The software developers that provided our SQL database program advised us to put the subscription expiration on "never expire" because of their past experience with customers who do not maintain their databases. Because of...more >>

This error is occurring always. SqlDumpExceptionHandler: Process 65 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process. (Source: SRVNT016-001 (Data source); Error number: S1000) Somebody can help me? ...more >>