Normally, the Snapshot create publication script only needs to lock the table long enough to generate a Create Table script for the Distribution Agent to apply to the Subscriber. However, the create Publication was being blocked on the Publisher. We discovered a database trigger used to AUDIT all schema modification on the Publisher was root
Read More »
Sateesh Yele Microsoft SQL Server Support Issue: Restore of a replicated database fails with the following message. Msg 3724, Level 16, State 2, Procedure sp_MSdrop_peertopeer_tables, Line 32 Cannot drop the table 'dbo.MSpeer_lsns' because it is being used for replication. Consider the following scenario. Transactional Replication is set on the database from a script and sp_addarticle
Read More »
How to Archive your SQL Errorlogs into a Table Chris Skorlinski Microsoft SQL Server Escalation Services Have you noticed your SQL Server errorlogs taking up a lot of disk space? Ever wonder what was logged a few weeks ago, but the logs have already rolled over? Why not create a SQL Agent job and archive
Read More »
Yes you can use both Transactional and Merge Replication to move data inserted using the BCP.exe utility of the Bulk Insert command to Subscribers. Considerations For Transactional Replication By default, Transactional Replication will replicate data loaded via BCP or Bulk Insert. For performance, you may want to load data using the bcp Utility –b batch_size
Read More »
José Moreira Neto Microsoft Escalation Engineer I ran into an issue where the customer was complaining that Merge Replication was generating “fake” conflicts. This customer has a straight SQL Server Merge Replication with no filters where the only non-default setting is the use of the Microsoft Maximum Conflict Resolver a very specialized feature in Merge
Read More »