Hi. I am developing an Windows Mobile 5.0 Application for the MotoQ. It uses merge replication and everything works fine. The DB has a dynamic filter on it so that it only sends the data that matches the SUSER_SNAME(). The problem arises when a user, other than the inital user for the pro...more >>

Using SQL2005 EE SP1 I'm trying to set up a simple transactional replication with initial snapshot (1st time on this server). I create the publisher and it says it's successful, however the error log shows: Job cannot run because LogReader subsystem failed to load. Job has been suspend...more >>

I've read several instances that when implementing Database Mirroring, all client connections are lost. A retry from client/s, applications, etc... will reconnect to the Failover. In order to compensate for the disconnect you should make use of TRY CATCH logic within your code. When goi...more >>

Hello there As part of sql failover clustering I add storage disk to hold sql server database 1. Does the storage area can be in Raid 5 for better perfomance and availability? 2. If I set two storange areas at the same network can i use replication to transfare data from main Storage ar...more >>

Hello there I have two servers: Publisher, Subscriber Between them there is transactional replication On both servers the recovery model is simple. If the publisher goes down and the database has been corrupted. and I need to recovery the last 3 hours of working. Can I use replication log ...more >>

Hello there From some investigations i've made it seems that transaction log for replication slowing performance. But on simple recovery model the transaction log used for transactional replication slowing performance less then recovery model full. I'm wondering whay. Does it because...more >>

Hi, is there any procedure or query to find out the transactions which are not yet replicated? RegarDs, Jacx...more >>

Hi, we are using merge replication from our server (SQL Server 2005) to what will soon be hundreds of subscribers. The subscribers are actually from a Windows app that uses a SQLCE database. The client app is able to insert and update records that are then merged up to the server. Everything I ha...more >>

I have an error that states..... DESCRIPTION: Replication-Replication Merge Subsystem: agent R99S-SQLA- EDI-EDI Merge to 00-r00s-sqla-2 failed. Publication 'EDI Merge to 00' does not exist. Due to the fact that there are other consultants setting up/deleteing replication & do not know how t...more >>

Hi, We have a one way transactional replication setup between 2 servers and use a remote distributor (push). All 3 boxes are SQL 2005, SP1. It runs fine for months at a time then every so often replication will get blocked for one reason or another. (typically a killed connection). If I then ...more >>

We are using SQL Server 2005 Service Pack 2 on WIn2003. We lost our distributor and I reinstall SQL Server in Distributor machine. Now I am not able to delete publication and subscription from publisher and subscriber. Any help highly appreciated. tried sp_removedbreplication Msg 37...more >>

Hi, I've come across another issue with my merge replication on SQL 2005 SP2. Every time it recreates the SPs or views (due to snapshot, or changes) it drops all of the custom persmissions to roles, or users. I found a "Copy permission" on the tables, but can't find it for views or pr...more >>

Hi everyone, We have a SQL replication that moves a large amount of data between our administration site and a production eCommerce platform at our hosting provider. The hardware at either end isn't especially taxed on either the source cluster or the destination cluster and bandwidth shou...more >>

Hi I have created merge publication using RMO programming on Sql Server 2005 and it will subscribe by Sql Server Mobile Edition. Publication created successfully and wok fine but I have to Configure Web synchronization manually instead of RMO programming. (In short Configuring IIS for web s...more >>

After losing my publishing server, I re-built on a new server. The databases had replication remnants so I ran cleanup scripts (Replication system Objects, indexes and rowguids) I then re-built replication I find that I have a column (rowguid) left over that I can not remove. The error ...more >>

Hi, i have a peer to peer replication set up between 2 databases. There was a parallel insert the databases are out of sync. i know the table where the difference is. Is there any stored procedure with which i can insert/update/delete without it being replicated? ...more >>

Hi all, I've noticed lately that I'm getting a few 28039 & 28040 Errors. The replication still seems to work though i.e. changes are synchronised. Any idea what the cause of these errors may be? Cheers. ...more >>

Is it possible to move the Distribution mdf/ldf files without completely breaking transactional replication under SQL 2000 ? I need to do this so I can get both distribution mdf/ldf files off single disk volumes (logical drives), and onto RAID arrays for fault tolerance. Current Setup: ...more >>

Am I right in my assumption that even if I pull an anonymous subscription from a Publisher with the snapshot publication located on the FTP server, I would still need to have TCP 1433 open to enable comunication from the subscribers to the publisher and not just TCP 21 for the FTP connectivity? ...more >>

Hi - When synchronizing, the following conflict occurred: INSERT statement conflicted with COLUMN FOREIGN KEY constraint 'FK_ContraintName'. The conflict occurred in database 'DatabaseName', table 'TableName', column 'PrimaryKeyCol'. The row was inserted at the publisher but si...more >>

Hi All, Maybe I'm being dense, but I can't figure out how to change the XXX in "Waiting xxx second(s) before polling for further changes." in my merge replication on my SQL 2005 Servers. When looking it up online I find references to pollinginterval, but the only reference in BOL to tha...more >>

Hi, I am seeing an unusual pop up when I try to hit the Website directory. I have setup replication setup for mobile units on IIS server. When I try to hit the - http://defaultwebsite/test/sqlcesa30.dll - it tells me to open, save for cancel the sqlcesa30.dll file. This is weird. I have n...more >>

SQL 2005 (SP1, +2153) Why does creating a Snapshot publication (with only stored procedures and functions) set the Transactional option on the Publisher? My intent is to create two separate publications (one Merge, the other Snapshot). The Merge publication contains the data articles (tab...more >>

What recovery model should I use for the distribution database? By default it is simple, but something tells me that this is not optimal. We are using SQL 2005 (SP1) with a Dynamic, horizontally partitioned Merge Publication. The publisher and distributer are separated. Thanks, hmscot...more >>

Hi, I have a situation where I need to perform a one way replication model to replicate SQL data from Africa(terrible satellite link - high latency and multiple dropped connections) to a SQL Server in Canada. Is there an SQL 2005 replication model that deals with these types of extremely un...more >>

I did find quickly answer to this question and I understand that it was possible for the Sql Server 2000 but I don't see this capability in SQL Server 2005. How can I implement transactional replication of database in SQL Server 2005 and Access .MDB file?...more >>

I am attempting to create a merge publication from SQL 2005 to SQL 2000. I am checking the 2005 & 2000 boxes for compatability, but receive this message. Publication 'edi' cannot be added to database 'EDI', because a publication with a higher compatibility level already exists. All merge pu...more >>

All, I'm looking for advice on the best practive for replicating data to a different server so that during server failure I can switch without any major delay. Any advice or clarification would be greatly appreciated. We are using sql server 2000 and 2005. Jamal ...more >>

I am using SQL Server 2000 and Enterprise Manager. I have a publication and I am trying to follow some instructions for configuring conflict resolution. I open the Publication properties, go to the Articles tab, open an Article by clicking the ellipses, and then go to the Resolver tab. All ...more >>

We are configuring merge replication with web synchronization and I was curious to know the extent of how the snapshot share is used. Specifically, does SQL Server only store the schema information here and is data ever stored there for any period of time. My reading indicates that the SQLCE...more >>

Hi all, I am a newbee at SQl and replication. But I have setup a Transactional replication model, the Source server is both publisher and Distributor, and SQL 2000 SP4 is used. The snapshot is created, but the distribution fails. And the following error is generated, 'ambiguous column n...more >>

Hello there If i use transactional replication on one server, can i set the recovery mode to be simple? ...more >>

Hi all, Wew have a need to change the sa password of all our servers. How can change in the sa password affect the replication. RegarDs, JerriN...more >>

Hi, I have a problem with a SQL 2000 transactional replication. It is a replication with subscriptions on several world wide located servers. A WAN connection has been disabled for some time and as result one subscription has been marked inactive. Message: "The subscription(s) have been marked ...more >>

Can a subscriber be a partitioned view? ...more >>

Hi, is there any documentation on how to setup a replication with SQL Server 2005 using FTP Snapshot? What is needed? We are trying to setup replication between 2 computer on a different domain and in couple month 3 more computers will replicate to the server too so using a username and pa...more >>

I'm wondering, which of the following is a better configuration overall ? Given: Publisher/Distributor on one large server Subscribers on multiple medium servers Publication consists of a single database on the Publisher/Distributor Continuous Transactional Replication to Subscribers Topol...more >>

Hi, We had a healthy 2-way merge replication set up with a SQL 2005 publisher/distributor and a SQL 2000 subscriber which had been running for about a week. I re-created the publication so I could add automatic identity range management to an article. I sucessfully re-created a push subscri...more >>

Hi We have many publication with many article. Each article has one row filter that match some criteria. This type of replication works fines at another database, but in this one (Dcrd035) happned this error below: The process could not execute ‘sp_relcmds’ on <Sql instance> and Invalid ...more >>

Vesrion: SQL Server 2000 sp4, windows 2000 Subscription expired, i have deleted and added subscription for reinitialization of the tables at target. Snapshot agent run fine, when distribution agent bulk copying data to target then i am getting the following error: The process could not bu...more >>

While reading "Inside Microsoft SQL Server 2005: The Storage Engine" the following paragraph is stated in terms of updates: In addition, the log will contain a singel record for each such updated row unless the table has an update trigger on it or is marked for replication. In these case...more >>

1) Can you use the Default Interactive Resolver with SQL Express and Merge Replication ? 2) Has anyone successfully done this? My setup is Windows XP Laptop with SQL Express, Windows Server 2003 with SQL Server 2005 Standard. I have setup Merge Replication between the two computers wher...more >>

Hi, I am not sure whether this is the best place to post. I was previously testing synchronization using merge replication. Now i am using web services instead. The web methods will pass a serializable datatable object. I am trying to synchronize a SQL Server 2005 database on desktop w...more >>

I have some Dell Axim X5 PocketPCs which show an operating system version (in the About) of "Microsoft PocketPC Version 4.20" and a copyright date of 2003. Since I have a handful of these 2003 PocketPC devices, ideally I'd rather not buy more hardware. I designed a solution a few years back...more >>

I tried to install the northwind script for 2000 and it failed in 2005 on the first line of creating database. Can someone send me the script for the sample northwind database on 2005 , the one that comes with the install ? ...more >>

I am curious to know if i script the replication scripts for creating publisher, publication,etc on 2000, can i safely run them on sql 2005 or are there some changes to the metadata ? Thanks ...more >>

Hi, I have replication between two instances of SQL2K. I have created the subscription with choosing option of "do not initialize schema and data...". Imagine I have Customers and Orders table in publisher and subscriber that CustomerID from orders references CustomerID in customers. Both publ...more >>

Hello there I create new transactional replication envirnment. If some server is being used as subsriber only as part of replication and no data is being changed there, Can i install minimal sql server on that server without many functionalitiys that normal server needs like: Locking, Agen...more >>

I recieved an error message, "The merge process could not retrieve column information for table 'dbo.TableName' -- sp_MSenumcolumns(?,?)" while doing merge replication using Sql 2000 and SqlCe. The database in question has 7 publications, 5 of which are working properly, and the other 2 spontane...more >>

I'm having trouble when trying to apply a snapshot to the subsciber. The distibution agent reports error "unexpected EOF found in BCP data file error" in addition it reports " duplicate key error". I have filtered the data being sent and choosen to delete the rows at the subscriber table tha...more >>