Is there an optimum "set and forget" value for automatic range identity? ...more >>

What are some things that would stop an article from being created? I am running a helpfully simple Snapshot Replication on my pc. I am configuring the SQL Server to do all three roles: Publisher, Distributor and Subscriber. I am only replicating the Authors table from the Pubs database to ...more >>

Can someone help me understand the what the differences are between the different types of bi-directional transactional replication, i.e 1) bi-directional transactional replication 2) transactional replication with queued updating, Thanks ...more >>

We are considering using replication for some of our needs and I need a few basic questions answered so I can let my boss know what some of the gotcha's are. Using transactional replication, distributor and publisher on the same serveer, read only subscribers: 1) What happens to the sub...more >>

I currently have 15 remote servers and one central server all running Win 2000 & SQL 2000 SP3, all doing merge & transactional replication. If I want to upgrade to SP4, do I have to do all servers at the same time, or can I do a couple each day, with out causing replication problems?? ...more >>

Win 2000 / SQL 2000 In EM, I cannot 'uncheck' an article in a publication. There is a push subscription from the server that has the publication. Does this need to be dropped first?? Is there an SP that will do this for me? AHIA, Larry.... ...more >>

My app is done in c# and controls merge replication programatically. Does anyone have any info on how to create a progress indicator for replication? I know that for the upcoming sql mobile, there are plans to include one in the data.sqlserverce namespace. But I have to program one for window...more >>

Hi, I have a base table in publisher db. I have a column, using which i want to filter it and replicate it to certain dbs. how do i dynamically do it ? Like for eg, consider this table : ID Project name center 1 A NY 2 B LON 3 ...more >>

hi i have sql 2000 sp3 and a merge publication with a filter. additional i have a client with msde also sp3 with is subscriber to the server-publication. the replication worked just fine for weeks. on one day i made a sync with lots of data. while synchronizing the computer shutdown into...more >>

Hi All, My replication process working well , meaning it replicates the data properly but it is not reflected in my 'Replication Monitor' , it always shows failure (Red shadow on the 'Publishers' and 'Agents-->Distribution Agents' .Note that the subsriber using 'push' method to ge...more >>

Hi, I was doing some testing of Identity columns with 'Not For Replication' and failovers. I wanted to test Identity column value ranges. Here is some back ground info. Both the Publisher and Subscriber have Identity column with the 'Not For Replication' clause. Both have the same (default)...more >>

using sql auth is there a way to save the pub & dist user/pass??!!?? everytime you sync you have to enter the password 4 times!!! -- Scott Kramer CDS Technologies, Inc. www.clevelanddata.com www.groundzerolan.com www.team501.com ...more >>

Hi, we have a merge replication SQL Server 200 solution that worked fine so far; 2 days ago we put a new table in replication and something new, that we didn't see before happened: for some reason not all the records where bcp in the new table for one of the subscriptions and there is a sp_u...more >>

Good morning All, In the context of a merge replica: Does this range serve as surrogate key (Primary Key) but after the sync, the server overlooks it when inserting new rows in the published table and generate a sequential one? Here's what I am trying to achieve: My disconnected users,...more >>

We have a SQL Server 2000 std edition on Win 2003 Server with 10+ offices around the country with with XP clients. Each office has about 5 to 10 clients with one of the client machines maintaining that offices' SQL database. These clients are not part of a corp domain. I want each office t...more >>

Hi, I'm trying to program (c#) merge replication with one publisher DB (SQL2000) and many subscribers (MSDE). I'm trying to find info and examples online, but it seems pretty scarce. If you can recommend a site, please let me know. Thanks, JJ ...more >>

I am setting up a SQL Server Database Filter based Merge Replication between Publisher (on Server Global) & Subscriber (on Server Site) using EXCHANGE_TYPE '1' (Data only needs to be merged from Subscriber(Site) to Publisher(Global) - Upload). You can consider this as a Central Subscriber mo...more >>

Hi, I have a few merge replication publication set up. I've tended to group articles in publications based on the size of the table - putting bigger tables by themselves and smaller tables together. As a consequence, some tables that have foreign key references are not grouped together in the ...more >>

Hello, Thinking about synchronous hardware based mirroring using EMCs clariion product line over a dedicated fiber connection between two geographically separate data centers. I realize that there is a basic speed of light issue here regarding the distance I can have between the two sites ...more >>

Hi all, I am not sure if this is the correct place to ask this quesion. The problem i am trying to solve is basically this. We do a nightly complete backup of our database. The next day we copy the database to a different machine restore it and run jobs on this database. I would like to au...more >>

I have a product that sits on a main server and wish to implement functionality to allow salesmen to come along, pick up a snapshot of the database, go away and maybe modify/add to it and then come back and "synchronise" their data. I'm reading up on Merge Replication for this purpose. But a...more >>

Will inserts/deletes go through an additional latency if the subscribing tables have a Primary key constraint to them as opposed to just having the indexes tied to the Primary Key. I guess there would be some as apparently all the replicated inserts/update/delete sprocs kick in on the subscriber,...more >>

Hi All: How can I disable the existing Pull Subscription in Merge replication? Also, I want to enable the Pull Subscription again. I had to reset my SQL Server in between a running pull subscription (Merge). It was replicating the data on other end. But after the local SQL server came up, Rem...more >>

Hi, I have a publisher and 3 subscribers. One subscriber stops with the folowing error: Number: -2147200996 Message: The process could not query row metadata at the 'Subscriber'. I start the merge-agent 2 more times, but I get the same error every time. What can I do to solve the probl...more >>

When i query msdistribution_status for commands to be delivered for a particular article, i see as an example 50,000 commands I did a group by xact_seqno for no. of rows present in msrepl_commands and to no surprise the rowcount comes to 50,000 commands However when i try to do the sp_browse...more >>

Hello all. We are just getting started with replication and I'm wondering if there is a way to not have deletes replicated. I know I could manually remove the delete trigger from every table but I'm intrested in have this a bit more automatic (like when its creating the subscription). T...more >>

Please help, I have set up a SQL replication between two databases. The process starts for the first time and it starts running, after about 30 minutes 1) It Connects to the Publishing Database 2) It Generates Schema Scripts Then I leave the screen and begin doing other work, when I com...more >>

Hi friends, I have a program that drops a table from a database that is being replicated. My procedure is to drop the subscription, drop the article from the publication, add the subscription and drop the table. When I exec sp_addsubscription I don't want to initialize the synchronizati...more >>

Is there any experience with SQL Server 2005 replication? I want to do replication via Internet without implement VPN or physical connection to SQL Server. I think that this is imposible with SQL Server 2000 but watch a presentation on TECHED which says that this is possible with SQL Server 2...more >>

Hello I am trying to find a way to automate the 'Generate SQL Script for Publicatios" that exist on Enterprie Manager. I would like something like the Script method from SQL-DMO. I use SQL-DMO to script all my SQL Server Jobs using a code like this: Set conServer = CreateObject("SQLDMO....more >>

Hi Kevin, I am setting up a SQL Server Database Merge Replication between Publisher (P) & Subscriber (S) using EXCHANGE_TYPE '1' (Data only needs to be merged from Subscriber to Publisher - Upload). Publisher priority is maximaum by default. However, I am facing this issue: Under norm...more >>

Hi, Does anybody know if I can have more than one distribution server for a publishing server ? explanation: I have a publishing server which contains 2 databases. I want to publish the first database to Distribution server 1, and database 2 to distribution server 2. Is this possible ...more >>

I got Distribution Agent failure however everything working correctly, it's allways red x on distribution agent. I have transactional replecation between two virtual computer, i replecate all tabels from my database, everything work correct however i got red X on replication monitor, on dist...more >>

Dear All, I have made a replication between Server A and B. It work well One date, the customer need to renew all data in one table. So I run a script to delete the data then try to import such data from another outside server. I used Sql server enterprise tool to import data,I make it...more >>

I have disabled parallelism for the server . Have you seen the replication agents(log and distrib specifically ) ever go through parallelism when they run , especially when there are large no. of commands to be distributed ? ...more >>

And forgive me for asking this over and over again.. My distribution agent states " 1 transaction with 100,000 commands were delivered " My default profile has the Commitbatchsize as 100 and CommitBatchThreshold as 1000. So in this case, how does distribution agent work ? Does it read/buf...more >>

Hi folks, We've had an ongoing saga with sorting out identity ranges in our sql server 2k db after restoring a copy of our production db into our test environment. i wrote scripts which check the identity value in each table to make sure the identity value is within the range constraint speci...more >>

Hi, We are trying to setup a two-way replication from STL to China. We know that the network is very unreliable, and not very good bandwidth. Inorder to decide if this is feasible, I need to provide information about how much data will we be replicating everyhour, and how big a transaction...more >>

(Portions previously posted in SQL Server CE newsgroup, and the compact framework newsgroup.) Ok, so I set up merge replication, got a table out to the client (iPaq w/ Windows Mobile 2003, compact framework), updated it, and am now attempting to replicate changes back to the back end. The ta...more >>

I am using 2 enterprise edition sql servers. After I promote the secondary to primary, and when I try to establish log shipping from new primary to secondary. I get the error as "A connection could not be made to any log shipping destination servers. You must register the destination server" ...more >>

I have scanned this newsgroup for similar postings, but came up empty. My problem is this: I had set up merge replication between SQL Server 2000 (publisher) and several MSDE SP3 subscribers. This was working until a week ago, but now nothing replicates. Symptoms: The merge agents in EM all ...more >>

Help ! I have a problem with some rows in a table in merge replication, that are different at some servers, though the Merge Agent keeps claiming that "No data needed to be merged". The validation of this table fails, of course. Do someone know the reasons of non-convergence of a row ? Is i...more >>

Hi, Please help me with the following scenario: I want to implement an application using eMbedded Visual C++ 3.0 (and then 4.0) to capture data locally on my Windows CE device by SQL (so, I would like to have an .sdf file on my device where I write data.) This data would be written continuo...more >>

HI all: How to use query to get Distribution DB name ? Cheers Nick ...more >>