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 >>

When I execute (MergePullSubscription)mPullSub.SynchronizationAgent.Synchronize() I get an error {"The MergeSynchronizationAgent class must be instantiated on a Single-Threaded Apartment (STA) thread."}, but as far as I can tell it is. I even added the attribure [STAThread] and still get th...more >>

Can somebody help please - i keep getting this erro when trying to sycn up my emulator to my Merged Replication DB. "The row update or insert cannot be reapplied due to an integrity violation. [,,,,,]" Anybody know what this problem could be? I have recently dropped an recreated a lot of ...more >>

Two Servers, 1st 2nd database a -------> after replication a' b' <------- after replication b on 1st server a is replicated to 2nd on 2nd server b is replicated to 1st I tried with merge replicati...more >>

Two Servers, 1st 2nd database a -------> after replication a' b' <------- after replication b on 1st server a is replicated to 2nd on 2nd server b is replicated to 1st I tried with merge replicati...more >>

The short story. Many branch databases need to be consolidated into one central database. Each branch has identical schemas: CREATE TABLE [Table1] ( [PK1] [int] NOT NULL , CONSTRAINT [PK_Table1] PRIMARY KEY ( [PK1] ) ON [PRIMARY] ) ON [PRIMARY] CREATE TABLE [Table2] ( [DBGU...more >>

Hi, I'm trying to remove the distribution database froma server, and it tells me that I can't b/c its used for replication. What table stores this info, its half cooked and I'm trying to manually cleanup the removal of the distributor and replication. -mike ...more >>

I found it odd that randomly, some of the table permissions at the subscriber of a transactional publication are removed after distribution. I've been testing the distribution of a transactional publication and occasionally when the distributor runs, it removes the security permissions on ...more >>

Hi, I need to replicate specific data fields to a contact folder on an MsExchange server. Is this something I could do with a DTS package or should I be looking elsewhere. If I can't set up a DTS package, what type of programming do I need to do to make this happen. Any suggestions or p...more >>

I recently had to restore a database from backup and the restored database had a different set of publications than the one I overwrote. Since then, in EM, on the Replication Monitor object, Publishers, and Servername objects as well as on the Agents and Snapshot Agents objects, I see the little...more >>

Someone here inadvertantly removed the distribution database leaving the replication configs hosed & also some orphan publications. I figured out how to clean all that up using the repl stored procs & the @ignore_distributor flag. Now, however we are unable to re-configure replication - can ...more >>

Hello, I've been beating around Oracle databases on Solaris for about 8 years. New to SQL Server...not a Microsoft programmer. Happy to be learning something new. I'm on a project which involves a hierarcy of SQL Servers, with multiple publishers replicating to single subscribers, using ...more >>

I am having a problem with sp_MSfetchidentityrange in a merge replication with one subscriber. The merge agent history shows the following 4 errors after executing the last command: exec sp_MSfetchidentityrange N'Capacity_Type', 0 exec sp_MSadd_merge_history 32, 6, N'The merge process coul...more >>

We are planning to move SQL server from SBS to windows server 2003. This means that we are setting up a server and will backup the existing DB and Restore it on the new server. I need require assistance in the setting up of replication to/from XXX server on the new server same as we are usin...more >>

Hi all, I will be migrating a production database to a new box. I will be using detach and attach db method to migrate, but I forsee that my replication job will break. Can anyone advise me on how to migrate the replication jobs over to the new db? Here is the sencario: DB-1 in Box A detach ...more >>

My (pull subscription) replication agents allow me to view each agent's job history and seasson details in the replication monitor (Enterprise Manager). How I can export this list to examine more closely outside of EM? TIA, ...more >>

I developed a Pocket PC app that uses merge replication in an isolated development environment. It worked fine. The I moved to the operational environment. Synchronization fails with error 2812, "Could not find stored procedure 'sp_MSgetmakegenerationapplock'". A little investigation shows tha...more >>

Hello... I have been trying to set and use a Custom Conflict Resolver for our Merge Replication (SQL Server 2000) and when I access the Articles tab/page and select the Resolver tab...all of the controls are disabled. Even when I create a new publication, these controls are disabled. ...more >>

Hello all, I have SQL 2000 with SP3 on both the primary and secondary servers. This is one-way transactional replication environment. I've just recently setup a number of databases for replication. Two of them keep getting following error. Both of these databases are very nearly the ...more >>

I can't restore trans replicated databases because I get message that they are in use - do I need to stop agents to get exclusive access - then restore - then restart agents? Thanks...more >>

Guys, Is two way replication possible in MS SQL server??? Can I do it with transactional replication??? If yes then which model do I need to use, Multiple publisher/multiple subscriber or updating subscriber??? Regards Jaideep ...more >>

We added data to a table with ‘<’ and ‘>’ symbols. The replication failed on SQLServer with the error “Syntax error or access violation”. We replaced the '<' and '>' with '(' and ')', which fixed the replication error. Can you not use brackets in a table that is replicated?...more >>

i know that it's natural that one publication could update three subscripers the transaction replication do that but i need the inverse case of that. i have three subscripers and i need any update in each of them appear in the original database. can i have a help? thanks for any one helps me. ...more >>

What is the sp command to add a new table to a publication, and to add the new article to each subscriber? TIA, Chris...more >>

I need information on setting up replication across domains. What kind of gotchas there are, what kind of trust relationships need to exist. All the gory details. :) Any links to resources would be most helpful. Thanks, Bob Castleman DBA Poseur ...more >>

I am adding a table to an existing publication that has one pull subscription using the steps listed below. When I run the snapshot agent, it does not recognize the newly added article ("no subscriptions needed initialization"). I WANT TO RUN THE SNAPSHOT FOR JUST ONE TABLE. Do I need t...more >>

Is there a way i can know the rows that where synchronised in th publisher after some updates are done on subcriber and synchronise to publishers?? Example say i update a table1 in subcriber and click synchronise an the data is updated in publisher But on publisher side i need to know what r...more >>

Is it possible to replicate some field from multiple tables (as result of select query with joins) at source to a single table a target ?? For example i have two tables at source 'source_table1' an 'source_table2' and one table at target namely 'target_table'. Now wan Field1 from 'source_ta...more >>

I was trying to add a new stored procedure at the publisher and found that through enterprise manager only tables and views are listed as articles. Is there a way to add a stored procedure and then have it replicated or do I have to manually add the stored procedure to each subscription? wb ...more >>

I need to do parallel snapshots for 2 transactional replication subscribers to one publication. Is this possible and how? The initial snapshots are taking longer and longer - I am now very close to running outside our mantenance windows and I need to be able to run the snapshots to both simul...more >>

I setup a snapshot with 2 subscribers I started one push agent - let it finish - stopped the agent and started the second push agent. The following error is returned almost immediately... .............bcp could not be opened. Operating System error code 5(Access Denied) ........... Any ideas?...more >>

Hi, how can be implemented republisher replication model? When I first configure and create a publication "P1", and then create pull subscripton on "RP1 = Publishing subscriber" everything is ok. But whenever I try to create a new Publication on RP1 I get an error message which says that befo...more >>