How do I / Can I use SQL 2005 Express Edition to subscribe to a SQL 2000 Publication? I attempted to use Windows Synchronizer to create an Anonymous Merge Subscription on a Laptop running Windows Vista Home Premium with SQL Server 2005 Express Edition. It 'complained' that SQL 2005 cannot s...more >>

Hi, In whatever version of SQL Server 2005, can I make merge or any other type of replication to replicate data only from subscriber to publisher (only upload changes)? -- Thanks, Oskar. ...more >>

I have a situation which I can't seem to find an answer to. I have merge replication set up in SQL2005 and everything seems to work find except that the row filter for a table isn't working 100%. I have 200 or so field guys who have SQL Express installed on their laptops who syncronize data back...more >>

I'm trying to evaluate the RedGate SQLCompare tool and it did a nice comparison between an up-to-date version and an older version of the same database. However, when I try to synchronize, it synchronizes the normal tables, then I get a message: The following error message was returned from...more >>

We are on SQL Server 2000 SP3 We are trying to get to SQL 2005, but cannot do that until we consolidate our databases so the upgrade will complete in a reasonable amount of time. I am trying to use bcp to copy data out from each database and move it into a centralized database. Of the 1...more >>

Hi All. SQL Server 2000, merge replication Record created by subscriber on subscriber DB (has ID not in publisher range) exists on publisher but on subscriber. We are using upload and download as a separated in time processes. Subscriber definitely re-subscribed at one point of time (got...more >>

I have 2 databases and plan to user transactional or snapshot replication to replicate data from db1 to db2. db1.table1 name char(20), addr char(500) and db2.table2 has entity char(20), addr1 char(100), addr2 char(100) etc. Table Names & column Names and different but type remain same. Can...more >>

Hi I need to know exactly the sequence of events in synchronous mirroring mode. What im reading is this: 1. tranaction recved from a client by primary 2. primary writes trans to trans log 3. log written to dbase ie to disk from log on primary and concurrently sends log to mirror. 4. Pri...more >>

How does conflicts happen in merge replication? Whether it is a) rows updated at the SAME TIME at different subscribers? Or b) synchronization is not depend on time but depend on when you synchronise it ? ...more >>

I have 2 questions, 1. In what circumstances a subscriber need a re-initialization? 2. When I re initialize the second time, Does it re applies the whole snapshot to the subscriber again or applies only the delta corrections? ...more >>

Just installed SQL Server 2K5 SP1-default install-using local acct-copied new db from another server-configured snapshot and merge agent using impersonate SQL settings ok-ran snapshot ok-ran merge agent and saw this in Monitor details Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'-error...more >>

we are replicating from SQL 2000 to Oracle via linked server. and are getting the following error "The process encountered invalid column data in bcp file", the bcp file is too big to investigate it, any one has any insight of this? ...more >>

How can I add an index to a article in a Merge publication and have that go to the subscribers? Thanks, Steve...more >>

after update from 2000SP4 to 2005SP2 I noticed two stored procedures having issue due to changed functionality of the @@IDENTITY vs. SCOPE_INDETITY(). I changed them on the publisher/distributor and regenrated the snapshot before marking subscriptions for reinitialization. Next sync supposed t...more >>

Publisher: Windows 2000 SP4 SQL2005 SP1 Subscriber:SQL Server Express Tablet XP SP2 If I have a subscription retention of 20 days and a subscriber never misses a 20 day window; aka they never "expire" because they always replicate within the retention period, what happens to the replicatio...more >>

Hello, I created a subscription programmatically so I have the CreateSyncAgentByDefaut property = false. Do I have to do some additional functions to work with and clean up the subscription metadata. Thanks for your help. ...more >>

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

Can anyone point me to a set of documented steps on how to clean up the following mess? Three days ago a developer (not me) deployed some changes to a production database by restoring from a backup created on another server. The problem is the production database was set for replication. No...more >>

Thanks for your response. I don't know how to do pass-through authentication across domain (particularly using SQL2k replication), I thought that would require a trusted account on both sides. I have been trying using the sql account and although I can connect to the subscriber using the acc...more >>

Dear all, I try to setup a replication between a database TEST on a server myServer into an SQL express database myDB on a Vista office PC machine. For that I define my SQL server to be a publisher of my database TEST and then on my Client PC under sqL express I define a new subscription b...more >>

Hello, There is a @identity_range parameter, which controls the identity range size initially allocated both to the publisher and to subscribers in sql server 2005 merge replication. I need to assign different identity ranges for publisher and subscribers. Is it possible to achieve it? The @...more >>

Hello, I have a problem with a MergeReplication. I have installed the Publisher and the Distributor. Then I created a MergePullSubscription. But when I want to generate the Snapshot I get the error: Message: Error in the Replication-Agent while creating the folder 'xyz' Stack: in Mi...more >>

I located the following titles and dates of courses being held in Chicago: 2071 Querying Microsoft SQL Server 2000 with Transact-SQL 04-05-07 2071 Querying Microsoft SQL Server 2000 with Transact-SQL 05-14-07 2071 Querying Microsoft SQL Server 2000 with Transact-SQL 07-16-07 2072 Admin...more >>

Can you push over non-trusted boundary? Hello All, Is it possible to use a Push Subcription (Transactional) pushed over non-trusted domain boundary? I've tried a lot of things without luck. Bill Millett ...more >>

I've got a publisher, distributor and subscriber on different servers and I want to move all 3 to different servers. Is there a way to restore the publishing database on the new publisher, the subscribing database on the new subscriber and then continue replication? knowing, of course, that...more >>

Hi Gurus, I have a default on a column that disappears every time I reinitialize replication. This is transactional replication to an updatable subscriber on SQL Server 2005. Yes, replication of defaults is turned on, and *most* of my column defaults do, in fact, replicate to the subscriber...more >>

I didn't actually see this but my customer swears: Merge replication subscriber sql 2000 sp3a had the jobs disappear from the agent for about 10 hours and the publisher said it could not connect. This morning the jobs are back and replication was able to be started manually. Help....more >>

I have 3 retail sites running MSDE and I want to aggregate sales data at a separate SQL Server. I run a VPN and I guess I need to use merge replication to a full SQL Server Database. My questions are 1. Is the central server the publisher or subscriber 2. The three sites tables are identic...more >>

I am trying to limit the downloaded records per merge session over my less reliable links. Under SQL2000 I could set MaxDownloadChanges in the agent profile to 1500, but in SQL2005 this value is limited to 300 max. Has anybody run into this issue before? Why was it changed from SQL2000 to SQ...more >>

Hi; I have a push suscriptions server that need acces to Internet (publisher) through proxy server computer. So I need configure proxy server account in Sql Server Suscriptions machine, because it run without desktop user sesion. How can configure it? Thanks in advanced M. Barro ...more >>

On my distribution server, I have a failed replication (the big red X) for a server that had hardware failure a couple of weeks ago. We were able to bring this client up on a separate server and have re-replicated them. Now I need to get rid of the failed replication however when I try to simp...more >>