We currently have SQL CE 2.0 installed on our PDA devices which replicates with SQL 2000 server. Recently, we have been receiving errors on some of the devices during the merge replication process. We have been receiving the following errors: Error:80040E21 Native Error:28566 Microsoft...more >>

How do you remove a bad publication from a SQL 2005 publication in replication monitor? There were errors when I first tried to create the publication (was resolved and the correct publication was created). But now I have two publications, one with just the publication with a red X and one t...more >>

I'm running snapshot replication and i want to add a step in my subscriber job to run a stored proc after my snapshot is applied. Since my subscriber job is continuous, i don't know how to handle this. My subscriber job as actually three steps, "Distribution Agent startup message.", "Run ag...more >>

Can anyone give me a clue as to do DataWarehousing using Replication Publisher/Subscriber? I have 4 Production Database's that I want to replicate to one database acting as a DataWarehouse. For the 4 production Databases I created a publication for each database. I then created a subscript...more >>

I am to be involved in moving 3 clusters soon from one data center in the Northeast to Texas. The main requirement is to have the shortest cutover period possible via some kind of replicated technologies. System 1 - 64-bit SQL Server 2000 SP4 to a like environment. I see no issue with t...more >>

My MsMerge_GenHistory has too many records (currently 1.6 million rows) and I can't get it to go down. One of my Merge publications accidentally had Subscription expire in XX days set to 70 days. My MsMerge_Contents and GenHistory filled up to 1.6 Million and 1.9 Million records before I ca...more >>

Dear Friends, I have a client server application which is deployed on two location. For same i have use the Merge replication but as the database was big i try to find out a simple solution by restoring the publisher database backup at subscriber and then run the agent which would save the ...more >>

Can anyone help with QueryTimeOut value, I have a replicated database with snapshot run every 30 minutes. The subscribers are Sales Reps with laptops using "pull" subscriptions. A few weeks ago, a number of laptops started getting a S1T00 ODBC timmeout error trying to do a synchronize. Is the...more >>

I have a few databases that are replicating over the internet and all but one is working properly. I have a single database that gives the following error: The process could not enumerate deletions at the 'subscriber'. If I manually run the agent it successfully completes, but it will fail ...more >>

SQL 2000 table too wide error: exceeds the maximum numberof bytes per row (8060). Does anyone know if there's any kind of whitepaper / KB Article from Microsoft which says whether or not they support this arrangement. We're a medical company and the regulations surrounding the release of...more >>

Dear Friends, I have a database which is a published for 3 subscriber with bit of variations. now while checking i found that there are 8870 system generated procedures in the database with name. ap_sel_0394BA4C0A144B4DB88E9E00ED0446B3_pal or similar way. please suggest do i need the same...more >>

Hello, We have about 150 subscribers and need to verify that certain ones are using certain custom merge agents. Is there a tsql query that can get us the name of the subscriber and which merge agent it is associated to? Thanks. Jake ...more >>

Hi to All, I have a Merge Replication on SQL2005 SP1 running on a Microsoft Server 2003 SP1. My Subscribers are 60 Handhelds. >From time to time when Handhelds try to Synch, we get Error 28562 on some of them and its usually resolved by warm booting the Handheld and then Re- Synch. I...more >>

I am expereiencing an unhandled win32 exception after calling the method Synchronize() of an object of the class Microsoft.SqlServer.Replication.MergeSynchronizationAgent in a VB .Net program. The synchronization process runs correctly when I start it using the synchronize command in t...more >>

Hi All, I have a replicated environment SQLServer2005 replicates to another SQLServer2005 Server. This works great. When i try to republish i receive the error "Publication 'PublicationName' cannot be added to database 'DatabaseName', because a publication with a higher compatibility level al...more >>

We currently use log shipping to 2 other servers for reporting. We want to use transactional replication instead, so that our reporting databases are always available (when the restore agent runs the database is unavailable for a few seconds) and to reduce the latency between changes in the main...more >>

I am still having difficulties setting up replication, so here is what I am doing and tell me if I am missing something 1. all 3 sites are not on a domain, they are on the same vpn 2. Configured idential account and password on all machines 3. set the SQL server and SQL Sqerver Agent to run u...more >>

Can a replica database be publisher and at the same time subscriber. If so, Is Merge replication OK for applying to go in this environment and how should I configure the replicas as a subscribers or publishers? Thanks for your answers. Car....more >>

We are working in SQL Server 2000 and cannot upgrade to 2005 until next year. In the meantime, we have an existing merge publication that includes two tables we would like to include in a second merge publication. Is this possible? If not, would it help to make the second publication transacti...more >>

I am having problems installing the SQL Server Compact Server Tools on my Vista laptop to allow me to connect my Mobile Device running SQL Server Compact directly yo my backend 2005 database through IIS. I have done this successfully with an XP machine so I'm not sure if it is Vista problem...more >>