Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / Other Technologies / Replication / July 2008

Tip: Looking for answers? Try searching our database.

merge replication sql 2005 64bit

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Darin - 29 Jul 2008 03:36 GMT
i was setting up merge replication and received a message that a table
couldn't be replicated because it has more than 254 columns. THe table
in question has 288 columns.

So  -  I can only replicate 254 columns?

Darin
Darin - 29 Jul 2008 04:05 GMT
I found on http://technet.microsoft.com/en-us/library/ms151749.aspx the
following statement:

If your application does not require column-level tracking, it is
recommended that you use row-level tracking (the default) because it
typically results in better synchronization performance. If row tracking
is used, the base table can include a maximum of 1,024 columns, but
columns must be filtered from the article so that a maximum of 246
columns is published. If column tracking is used, the base table can
include a maximum of 246 columns.

WHY? I am not doing column tracking (I think, how can i tell), but i
have one table that has 288 columns in it (90% of them are bit data
type). Why is the number of columns allowed so small? I thought it might
have to do w/ the database compatibility version, but i have a database
created on SQL 2005 that has compatibility set to SQL Server 2005 (90)
and i still get the same message - that my table has more than 246
columns.

I did see that transactional replication allows 1024 columns - why
wouldn't merge allow the same number?? This makes no sense and really
messes up our database.

Darin
Darin - 29 Jul 2008 04:07 GMT
I saw on http://msdn.microsoft.com/en-us/library/ms143432.aspx that the
maximum number of articles is 256, but i would swear we are replicating
about 342 articles - is that impossible?

Darin
Darin - 29 Jul 2008 13:00 GMT
I checked on a customer's machine and we are replicating 269 tables.

Darin
Hilary Cotter - 30 Jul 2008 12:13 GMT
There are issues with the wizard in replicating this many articles. In
script you can exceed this number. In SQL 2008 they are more strict
and you will be unable to exceed the article limit in script and in
the wizard.

> I checked on a customer's machine and we are replicating 269 tables.
>
> Darin
>
> *** Sent via Developersdexhttp://www.developersdex.com***
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.