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