We have our data replicated to a group of read only servers in order to scale out. My question is since all the requests to these subscribers are just in the form of sprocs that do selects, i would like to have all these sprocs use a nolock hint as I dont think i need to worry about dirty d...more >>

In SQL 2000, the tree of databases was sorted by database names. The tree in the replication monitor in SQL 2005 seems to sort them in the order they were created. Is there a way to get them sorted by name? The tree is basically unusable for large numbers of databases if there is no obvious...more >>

What is Microsoft best practices with database backup plan with database integrity check using SQL Server transactional replication? Is there a Microsoft article that I reference with this information? Thank You,...more >>

I have created a transactional Replication from Publisher A To Subscriber B. Then I Created B as a publisher to subscriber C. The three databses are in sync. I am doing full and Transactional Backups on all these databases. If Database C Fails and the replication from B to C fails. How can ...more >>

Hi, I have a table published on the publisher. But when I add an index to the table it's not replicated to the device. I have checked the snapshot folder and the newly added index is in the .dri file. Any ideas? Cheers, Justin ...more >>

I have a new merge replication application I am working on. I have the publication/distributor setup on the server (windows 2003/SQL Server 2000 sp3a), and My client application is using the COM SQLMerge objects and SQLError Object. I have the appliation setup so that on the first attempt ...more >>

Hello, I have a strange one. I have 2 identical databases (different data, same schema). I'm trying to add some new merge replication publications to each of them. In one of the databases, the snapshot agent runs perfectly for all the publications, but in the other one, the snapshot...more >>

I'm running snapshot Oracle 9i to SQL 2005 replication, where my SQL 2005 box acts as the distributor and subscriber. Each morning, when replication runs, the snapshot creates a new folder shared replication folder (REPLDATA) that contains the scripts required to populate my SQL database. ...more >>

Crazy question, I know. We have two active-active SQL Server clusters, one at each of two data centers, that replicate data via SQL Server replication. One will be upgraded to SQL Server 2005 64 bit Enterprise while the other will stay at SQL Server 2000 32 bit Enterprise. Will they still be abl...more >>

Hi, Can subscriber have both push and pull subscription to the same publication?...more >>

I've configured web synchronisation for merge replication and developed a simple windows app with a "Sync" button. I'm now trying to display the merge sync status. the code are as following: Dim subscription As MergePullSubscription Dim agent As MergeSynchronizationAgent agent=subscri...more >>

Need to add an article to merge pub using sp_addmergearticle. Getting the following error: Server: Msg 20086, Level 16, State 1, Procedure sp_addmergearticle, Line 470 Publication 'fxDB6_Merge' does not support the nosync type because it contains a table that does not have a rowguidcol col...more >>

Hi, In the second page of wizard for configuring an instance to become publisher, we can supply multiple servers as distributor. 1) How does replication work in the situation that a publisher, has more than one distributor? 2) How can a subscriber say: I need to replicate my data using particul...more >>

Hi I have to use Merge replication (as oppose to transaction) because we use MSDE, in order to have similar functionality I want to make very frequent updates Is it possible/recommended to replicate every 10 minutes Thank you, Samuel Shulman ...more >>

Hi, We're creating an app that will use Merge Replication to SQL Server Everywhere, so we'll be using web synchronization. Every cycle (twice a month) there will be a lot of new data to be synchronized, and many subscribers (thousands) trying to get the new data within the first couple of d...more >>

We have the below requirement: We need high performing read/write capacity for users across globe (concurrency appx 20K users). Users can work offline and later synchronize data. Data synchronization frequency is medium to high (every hour or so). Data size that has to be synchronized is als...more >>

Situation: 2000 Publisher 2000 Distributor Some 2000 and MSDE Transactional extraction suscribers working good and without problems Now, I want to test 2005 Subscriber (all components are installed and in local all work well: publisher,distributor and suscriber test) Bute When I triyint...more >>

While running the wizard to create a new publication I was asked to choose between option 1 and 2 1. Unique identifier columns will be added to tables 2. Identity columns require the not for replication option I am not sure what is the difference and which one is generally recommended ...more >>

I get the following error (When I try to set a server as a Distributer/Publisher): SQL server Agent on "abc" currently uses the system account and finishes saying that the replicaton will fail I tried to assign another account but I can't figure out what sort of account is necessary Samue...more >>

Can I implement replication between 2 installations of SQL Server express? Where can I find out more about replication in SQL server Express? Thank you, Samuel Shulman ...more >>

I have a few tables which contains triggers and worked fine before joined the replication as a subscriber. The triggers are working only when the data is inserted or updated not from publisher. If the data is replicated by a publisher, no triggers are fired. What would cause this problem? ...more >>

I was in the process of creating a new publication in my database. This is the first publication to get created in the database, so the process had to also setup the server as a distributor as well as create the publication. I had specified dynamic filtering and specified to use my users tab...more >>

Hi, SQL 2000 sp3a The problem I face is that from time to time when I have to take down the repl (i.e. - a change in chema) it takes a long time to bring back the replication up. Is there a way to shorten that time. ...more >>

sp_expired_subscription_cleanup checks the status of all subscriptions every 24 hours. If any of the subscriptions are out-of-date, that is, have lost contact with the Publisher for too long a period, the publication is declared expired and the traces of the subscription are cleaned up at the ...more >>

Due to some troubleshooting issue, i have to unplug the replication server from LAN but when i plug replication server back on LAN. I got the error message at distribution agent that "The agent is suspect. No response within last 10 minutes" while snapshot agent had run successfully. I have inc...more >>

I am trying to setup Transactional Replication with Updateable subscriptions(MSSQL 2005). So far everything has been working correctly. I have run into one MAJOR issue however as I started testing my apps. Both the servers I have a Stored Procedure that inserts multiple rows into some tables...more >>

i've managed to make my web sync for merge replication working properly. now i've developed a simple windows app with a "Sync" button, but to make it easier for users, i'd like to add a progress bar. does anyone know how to do that or probably where i can look at? thank you!! carol...more >>

I'm a newbie to SQL 2000, and I'm not a DBA, but I've been given the task of setting up replication between 2 servers. I configured the 2 servers as I thought it would be for Transactional Replication. The replication looks like it worked, but when I look in Enterprise Manager, the DBs do not ...more >>

All, If a Transactional publication has NO subscribers. will hte transaction log still queue up transactions? -DB in simple recovery. thanks Sherpa ...more >>

I have two tables that are getting conflicts between the subscriber and the publisher, however I am pretty sure we only update these tables at the subscriber. I have column level tracking turned on. The tables both have Nonoverlapping, single subscription (3) set for partition options. I...more >>