Hi, I already have a merge replication setup successfully. However I now need to change the network from a central publisher to a central publisher with remote distributor See http://www.databasejournal.com/features/mssql/article.php/1458491 and Ctrl+F for the words central publisher. ...more >>

Can I have a detailed step to step guide for implementing the SQL Server Replication. Note : I am using SQL 2000 Server Ent. Edition. on Win2003 Server Platform Shanthi...more >>

Hi, I have a merge replication between MSSQL2005 as a server, and SQLExpress as the clients. The publication contains dynamic filters, ~190 tables and ~300 joins (the longest path in a "join tree" is 12), currently I'm testing on database that contains ~2GB of data. If I use a precomputed p...more >>

Hello, I have merge replication running on SQL Server 2005 Developer Edition. To be able to use my own conflict handler I implemented and deployed my own BusinessLogicModule written in C#. Till here everything works fine but I do not know how to handle the following scenarios: 1) When, w...more >>

Hi I am doing replication first time .i am having 4 master tables which want to replicate to remote location through vpn connectivity.and the tables contain around 5 lakhs of master records.i want to replicate each modified datas.which type of replication i have to use here, snapshot,transact...more >>

Hi We have a serious problem with a merge replication that has been running successfully until some rows were added to one of the tables and now SQL Server is issuing the following error message The schema definition of base table 'dbo'.'cmqb_open' at the Subscriber does not match the ta...more >>

We have started experiencing "System.InvalidOperationException: Internal ..Net Framework Data Provider error 6" exceptions from our Visual Studio 2005 applications since implementing Mirroring with SQL Server 2005. If we change our connection string so that it does not include the Failover ...more >>

Hello , I scripted the creation of my Replication , Then droped the Replication , Added 1 or 2 new Fields in 5 existing tables and then Recreated the Replication using the scripted File. The Replication is Created Succesfully but I got an Error when running the Snapshot Agent The Erro...more >>

Hi Everyone, I have a small issue in looking at the the subscription's job history (transaction history) on SQL Server 2005 subscriber subscribed to a SQL Server 2000 publication. We have the following environments set up and running and all the Windows and SQL servers service packed to the...more >>

Hi All, I have setup a transactional replication between 2 SQL 2005 servers. Unfortunately, I am getting the error listed below: Replication-Replication Distribution Subsystem: agent JFCIS3TRM02-JFJDAT-JFJDAT_PUBLICATION-JFCIS3TRM01-13 failed. Violation of PRIMARY KEY constraint 'ARSTRU...more >>

When we start multiple publications at the same time on the same publisher and even against different published datatabases, at times, we run into deadlocks and start all over again. This was in 2000. Do we know, if in 2005, the chances of deadlocks are minimized if i start multiple publica...more >>

Setup: SQL Server 2005 -> Merge pull subscription via HTTPS Tables: 1) StudioType (Id [tinyint] PK, Name [nvarchar]) 2) Studio (Id [int] PK, StudioTypeId [tinyint] FK, ComputerName [nvarchar]...) 3) etc Remarks: I have a single parametrized filter (for the entire database) on article St...more >>

In DTS whenever the data was imported to tables in replication, the merge tracking triggers were not getting fired. There was an option FAST LOAD / BULK load (not sure) which was required to be deselected. I am using SSIS and find that the triggers are not fired even here. Does anyone ...more >>

Our distribution database in up to 9 GBs, after only 3 weeks... What job cleans out data from this database? What do I need to check to verify this? -- Thanks and God Bless, ThomBeaux...more >>

Hello folks, I currently have a "live" DB and a "reporting" DB, both SQL 2005. Each night a full backup of "live" is restored into "reporting" which gives my users what they need - access to a copy of "live" with no danger of screwing up the production service. We do however add a few ind...more >>

Hi guys, I have two separate system with some data common between them. For simplicity let's say System A contains some data that is same with System B. Now I want to get the data from System A to System B by merge replication (dont want to send data from System B to System A - using merge ...more >>

Have a live and standby server and failed over to the standby after (i thought) using EM to turn off replication. Now find out that the ms_replication_table on the subscriber is growing - what have I missed ? The very least I need to do is remove/delete this table as I now don't have eno...more >>

I have a server that has become unstable. My tasks in the next 2 days: Complete a full system backup of the source server complete a full system restore to the destination server unplug the old system plug in the new system Backup / Restore software: Veritas Backup Exec Because of the...more >>

This may be a dumb question. Can SQL server express do pull subscription? I find out Sql server express doesn't come with SQL server agent, does pull subscription need the server agent to do the pull job? Thanks for any help. KL ...more >>

Hi How do i configure web syncroniztion using RMO programming insted of Wizard . In short configure IIS using RMO or T-SQL . Thanks ...more >>

Hi I have created merge publication using RMO programming on Sql Server 2005 and it is subscribe by Sql Server Mobile Edition. Application Details: Application: Windows Mobile 5.0 Pocket PC . Language: C# Dot Net Version: 2.0 Database: Sql Server 2005 For Publ...more >>

This is a follow up to my post 7/30/2007 <please review> I have been unsuccessful in removing this column do I have to rebuild from scripts then migrate data? Thanks Mark J. Soule ...more >>

Hi, I am doing replication between SQL Server 2005 on desktop server and SQL Mobile on mobile device client, following the guide here http://msdn2.microsoft.com/en-US/library/aa454892.aspx 1. I realised that when I do any form of adding, editing, deleting from my mobile, the changes get ...more >>