Replication: Help! I lost a replication system stored procedure

“Could not find stored procedure MSMERGE_INS/UPD/DEL_SP_XXXXXXXXXX” If you have replication set up on a SQL Server 2005 (any build post SP2) or SQL 2008, and you receive a similar error as the one mentioned above, there is a way to resolve this issue without having to reinitialize / drop – create your publication. http://msdn.microsoft.com/en-us/library/bb326615.aspx SP_VUPGRADE_MERGEOBJECTS…

0

Replication: Merge Filters – optimize optimize optimize

I noticed that many people overlook optimizing their filters in a merge replication topology. This is crucial to performance and attempting to tweak the replication itself (example: using pre-computed partitions) may not be sufficient. An example of such: All the join filters specified against the published articles in merge publication would be evaluated during DML…

0

Replication: Partitioned snapshot fails with "Incorrect syntax near" message when article name has more than 40 characters

Repro: ** note: if you will be trying this repro – please remember to alter the script to suit your environment (Example: @web_synchronization_url) ** SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[tbl_Thisisareallylongtablenametoemphisetheissue](     [Col] [uniqueidentifier] ROWGUIDCOL  NOT NULL CONSTRAINT [DF__tbl_Activ__Activ__084B3915]  DEFAULT (newsequentialid()),     [Col2] [uniqueidentifier] NOT NULL,    …

0