SQL 2005 Developer Edition (R&D environment)

According to TechNet, there is a limit of 246 columns for merge replication.

Problem I have is, I've got a table with 234 columns (235 after SQL adds the rowguid [I just started here, so don't blame me for that design]). When I try the entire table, SQL generates an error when creating the snapshot:

"String or binary data would be truncated.
Cannot find the object 'MSmerge_sel_AB2BF39C19C246C7AF412E0A204C45BD', because it does not exist or you do not have permission.
Failed to generate merge replication stored procedures for article '<article>'."

When I select columns to included, it fails once I add the 209th column (works fine when I have 208 or less columns selected).

I have the same problems on a second table with 227 columns (before the rowguid).

Help greatly appreciated (I'm new to merge replication--never had problems with transactional :-) ).


-Tim

No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.488 / Virus Database: 269.13.33/1034 - Release Date: 9/27/2007 5:00 PM


MS Sql Server LazyDBA home page