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

Hi, I have a requirement wherein I have some tables in SQL Server which needs to be synchronized itself with oracle. SQL Server 2000 contains the tables (Copy) Oracle 8i contains the Master tables(Acutal data) Please let me know how can we achieve this.....Methods of implementation...more >>

Guys, How do I change Identity Increment values. For eg: currently on table ABC I have identity seed value starts from 1 and increment by 1. I want to set identity seed value = 100001 and increment by 2. Help with any script most appreciated. Regards Javed ...more >>

Hi, Our company has several branches and we need to get new records and changes from these branches into our main office. The main server will not send any information to branches. The data is inserted at each branch and must be replicated to main server. If any changes made at the branch, it m...more >>

What are the "best practices" for calling sp_publication_validation to validate a transactional publication? I am distributing a transactional publication once a day to the subscribers and I would like the data validated daily. When should one call the data validation sproc, before or afte...more >>

If someone could tell me how to solve the error: The process could not bulk copy out of table '[dbo].[syncobj_0x4530303342304638]'. I/O error while writing BCP data-file (Source: ODBC SQL Server Driver (ODBC); Error number: 0) Thanks ...more >>

After create the publication of snapshot replication. and manually start the agency. The subscription properties window shows the status is 'Pending' How can to manually start the data transfer without waiting. Thanks ...more >>

Do I need to buy license for replication in SQL Server 2005 Express version? Or it is totally free?...more >>

Guys, I am new to MS SQL server replication. As of now, I am trying to spec thngs out. What is the difference between Multiple Publisher/Multiple subscriber scenario and Updating Subscriber scenario??? Both seem to me as a Sybase DBA as Multiple master scenario as both have the same data and r...more >>

I have setup transactional replication with no snapshot. I created a new table on publisher side and I would want the table also to be replicated. Here is what i did- - drop the subscription - create/dts table to subscriber - create insert update stored procedures at subscriber(i have create...more >>

Hi All !!! I try to disable publishing and distribution on 'MyServerName' (SQL server 2000), however i got the following error : SQL Server Enterprise Manager could not disable publishing on 'MyServerName' Also the distribution database doesn't exists on this server, my coleuge dropped...more >>

Hello All, I have a SQL Server database up and running on my domain... I want that to act as a replication server for my other 2 database servers.... is there a specific place anyone would recommend that I go.. to start this off on the right foot.. in regards to LEARNING the way to set this...more >>

can any body help is sql replication is possibel when we have sql installed on servers who have diffrent ip addresses. here i have three sql servers two servers are are installed at localley and one is at remote side. my remote side server is having diffrent ip address when i try to regist...more >>

I use merge replication. Client db is MSDE when I synchronize I get the data but just before finish sql server execute "sp_msgetmetadatabatch" for 15-20 minutes. What can be the reason? ...more >>

Dear folks, Initially I restore a database backup to 2 instances and set up transactional replication among them. The snapshot agent generates articles successfully. When it push the publication from publisher to subscriber, after a number of schema scripts applied successfully, it prompt...more >>

Hi, I would like to know if I can do Replication from a MSDE 2000 to another MSDE 2000 system (one way). All I need to do is Sync Server database changes on to a Workstation database(Real-Time). Let me give an example. We have Server and Workstation product. Our Server will have a Live...more >>

Is there any nightly maintenance tasks I can run that will keep my replication going smooth? I remember reading somewhere about re-indexing replication tables, but could somebody offer some more insight as to what I could do to keep everything afloat? Best Regards, Brad ...more >>

Hello, I am creating a custom job that will publish several publications to subscribers. I will NOT be using the auto-generated jobs created by SQL Server to perform these tasks, and instead I am performing this activity in my custom job. I copied the job steps from the SQL generated jobs ...more >>

Hello, I'm hoping someone can help me out here... BACKGROUND: I'm trying to replicate a bunch of tables, and am having difficulty figuring out how to handle keys/indices/constraints. The project is focused on co-locating a production database. So, I have data feeds going into my publishe...more >>

Okay, this is a real bummer. I setup a one way replication from one SQL server to another. Now, the data types and lengths in some of my tables needs to change to fit a new data structure but I keep receiving and error that SQL cannot drop the table because it is replicated. I can make the cha...more >>

I am trying to configure Merge replication such that remote client data is consolidated at the sql server level using the internet.We have 150 msde clients which are located all across USA. I have to give them an application which will enable each client to configure the client network utility...more >>

Paul, Thanks for the quick answer. I think I found out what was the problem. Application which loads the data packs huge transactions. Sometimes transactions have around 60,000 commands (I cannot do anything about that, third-party application). So I'm guessing that if such transaction is being ...more >>

I am trying to set up a central subscriber topology (seven small databases replicating into one large database). The requirement I am having trouble with is that updates need to be made to the central subscriber and get replicated back to the publisher DB they belong to. This is why this to...more >>

Hi, We have transactional replication between 2 (sql server 2000 sp3) servers accross VPN. It is scheduled to run every 5 minutes, between 11PM and 7AM (all agents). However, when I checked agents at 10AM this morning, they were still running. What could be an issue here? Thanks, Eddie ...more >>

Hello, All! MS SQL 2k EE SP3a, merge replication. After long time Conflict Viewer began to hang when viewing conflicts on some articles (not on all). There is no waiting locks. Workload is minimal. What's wrong? Thanx in advance. ...more >>

Hi, I am looking through books on-line but an not finding what I am looking for. In my stored proc, I am being passed a varchar field, 20 long. It looks something like, '103098-1' I need to split the characters on the left side of the '-' into one field, and the characters on the right sid...more >>

Hi, Our production historical database got the "Detect nonlogged agent shutdown" error message from transactional replication once a week. How can I solve this problem? Can someone help me? Regards! Chen...more >>

Dear Friends I have created a Mearge Replication with name TEST for database DBTEST I have deleted the same Replicaiton but now in my Database DBTEST i see the tables with name Conflict_TEST_TableName How i can clean the same. Your guidance will enable me to solve the problem. Than...more >>

Hi I am looking to solve an issue with replicating table and column names that contain spaces. I originally thought that SP4 would solve this issue however after installing Service Pack on both the Publisher and Subscriber I still receive the "access violation or syntax errror". I looked ar...more >>

Hi, I have found many view objects starting with the 'syncobj_0x' in publication database but I can't drop these views because of dependancy on itself. How can I purge them? Thx Ron ...more >>