We're looking at implementing transaction replication over log shipping. Our question is if it's ever possible for the subscriber server to ever block the publisher due to the subscriber's momentary inability to keep up with transaction volume (we're looking at identical hardware, but will be us...more >>

Got the error and not too sure why "The subscription(s) have been marked inactive and must be reinitialized. NoSync subscriptions will need to be dropped and recreated." Its strange.. A lot of my subscriptions have been throwing the error of late on a particular server. Why does it happ...more >>

I need to set up replication between 2 servers (both running SQL 2000 SP4) in 1 domain with a network connection. I haven't done this before and am not finding much in the way of step-by-step instructions or best practices online or in BOL. There is a lot of money involved and I don't want t...more >>

I have a series of publisher/ distributors that replicat to one subscriber. The replication was off-line across the weekend and now most of the subscriptions are marked inactive / needs reinitialization. When I try to reinitialize I get a message box saying "SQL Server Enterprise Manager co...more >>

Hi Guys, I need a little advice. I need to delete 250000 rows on a monthly basis and my users are using MSDE 2000 with merge replication, publisher is SQL Server 2000 Standard. The users will never be uploading or making changes to this table. Is there any way i can make this a quick del...more >>

Hi - I want to change the precision/scale on a decimal datatype on a field which is in a replicated table (merge). I tried to alter the field on the publisher but I receive a message saying that I can't do this due to the table being a replicated table. Anyone know tips on how to do this (with...more >>

I have a publication defined with the default sync_method of native. I have 1 subscriber subscribing to that publication . I am adding a new subscriber and want to subscribe to it with the concurrent option. Can I change the publication property without affecting the existing subscriber and if...more >>

From time to time I have a very strange occurrence in regard to = replication, I have an attempt to write a row which already exists in my = replicated database & the ONLY way the row can arrive in this database = is via replication. The replicated database is used for reporting, = therefore, u...more >>

Can anyone tell me what should be contained in MSrepl_identity_range tables on both the subscriber and the publisher? Both my tables contain completly different data - pub has 83 rows and my single sub has only 3. When are these tables populated and how? Can I populate them manually from a ...more >>

Does anyone know what script I need to run to recreate the replication system objects in MSSQL? I believe it's in the Install Directory after installing SQL? Will it destroy any existing publications/subscriptions on the server? I have 2 other publications that are running I want to keep. ...more >>

Hi Guys, I wondered if you would be able to assist on this one....? I have a server with several publications, all going to databases on one subscriber at a remote site. Some of the DBs work fine with snapshot replication and need no further attention. However, several of the DBs fail o...more >>

Hi I have a client which has a merge subscription - anonymous ftp When synchronising we see the following error message at the publisher: Error Message: The merge process could not retrieve column information for table 'dbo.Transfer'. (Source: Merge Replication Provider (Agent); Error ...more >>

Hi, I want to increase query timeout value but I don't know how to do this. Please advise me where to change query timeout value. Is it possible to set this for a particular database? Thanks, Soura. ...more >>

OK. I'm officially insane. I've managed to create an orphaned push subscription. I deleted the subscribers from EM via the publisher screen, then I deleted the publishers. But under replication|subscribers there is still a subscriber to a publication that does not exist. It seems my effo...more >>

Hello. Does anyone have instructions on how to set back up replication that has been marked for re-initilization thru the gui (enterprise manager)? We have a subscriber that had their wan link down for the whole weekend and now all their publications are marked for reinitialization. Some ...more >>

In testing (learning?) I added a table to a database after a publication was created. Then I went to modify that publication but the new table didn't show up in the list of articles. But when I did this with a view it did show up. Is there something about new tables that prevents them from sho...more >>

According to Hillary's book, the table MSRepl_commands contains the commands necessary to sync between publishe and subscriber. In my test database, this is currently empty. This leads me to assume that these entries are deleted as the subcribers are fully synched. Is this correct? Also, how a...more >>

Hello Guys, I have set up a transactional replication with 2pc's. One server is the publisher & the distributor, and the other one is the subscriber. Everything is fine, but the replication stops when my partner shut down the subscriber pc, now I have to restart the replication, but I don't ...more >>

Hello..I am going to implement Merge Replication with MSDE 2000. please let me know how many users MSDE 2000 can burden the workload. It will degrade the preformance if more than 5 concurrent user will start work on it concurrently. What is the procedure in order to implement merge Replication o...more >>