October 30, 2006 at 10:43 am
In SQL Server 2000, I've run into the limitation where you can only have 255 columns in a table when doing transactional replication. Does anyone know if there is a fix for this?
please help
Ole
October 30, 2006 at 11:40 am
I do not know of one. You also have a limiation of total width of the rows... and replication supposedly adds a column (with a particular name that I do not remember) if that column does not exist. This can (could) blow both limitations.
Thank-you,
David Russell
Any Cloud, Any Database, Oracle since 1982
October 31, 2006 at 2:48 am
ms_repl_tran_version is created in order for replication to track versions of rows so it can know which is the latest when using updateable subscriptions.
I don't think there is a work around for the number of columns. However you may want to consider splitting the table in to segments.
255 columns sounds a bit excessive to me.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply