SQL Server Replication - SPs or RMO programming
The SQL Server 2008 shall be installed on a server PC. The replications shall be configured between the two servers (Express and Server). The data updated into the local Express …
Cannot resolve the collation conflict between …
Feb 22, 2011 · Replication is setup to not drop and recreate table on the branches. I can subscribe to the master data publication and apply the initial snapshot on all branches which …
How to create the peer to peer replication with scripts
May 13, 2010 · About the sp_addarticle column Used to specify columns included in an article to vertically filter data in a published table. This stored procedure is executed at the Publisher on …
Disadvantage of Transactional Replication
May 3, 2012 · The number one drawback of transactional replication is its native inability to replicate batch commands quickly and consequently no predictable latency. There are ways of …
Changed the password of distributor_admin account manually and …
Jul 29, 2013 · Do not change the password for the distributor_admin manually. Always use the sp_changedistributor_password stored procedure, or the Distributor Properties or Update …
SQL merge replications fails only over VPN
Sep 1, 2014 · - SQL replication is working well in the local Area Network. - All Firewall Profiles are equaly configuired fpr replication. - VPN client can Ping SQL Server. - SQL Server can Ping …
how to turn the sync with backup option on distribution database ...
Nov 26, 2012 · I have the transactional replication enabled for the reporting purpose.I need to plan for the disaster recovery also.I came across the strategy for backing up the distribution …
Subscription Error: The current transaction cannot be committed …
Nov 6, 2015 · Can I ask you for another help. Now, I start creating replication in the production servers. I want to replicate a database from a SQL 2008 server to a SQL 2012 server. I …
Moving Remote Distibutor (Merge Replication)
Oct 8, 2008 · I have a Merge Replication setup with in a production enviroment with hundreds of active subscribers and need to break out my distributor to a seperate box. Right now the …
Replicating Views In Transactional Replication
Jul 23, 2010 · 2.When replicating Views, is there a way to have them replicated to the views sub folder under the database ( to have all the articles placed in their own respective sub-folders …