Showing posts with label messagethe. Show all posts
Showing posts with label messagethe. Show all posts

Monday, March 19, 2012

Number limit of table columns in transactional replication

I was setting up transactional replication for a big table and got the
following error message:
The article cannot be created on table 'TEST' because it has more than 255
columns
Is that the limit of replication in SQL Server 2000? If yes, Is there any
way to increase the limit, or it can be configured?
Thanks!
This is the limit and it isn't configurable . One possible solution is to
partition the table into smaller tables and replicate each one separately.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)