Friday, February 24, 2012

Column limit in Sql Server 2000 replication?

I am being told that the colid in syscolumns may not exceed 255 if the table is replicated. Is that true? Where in BOL or elsewhere can I read-up on this? This is a shocking development!!!

Ok guys, I found my answer in BOL!

"Be aware of maximum column and row sizes. A table used in snapshot replication or transactional replication can have a maximum of 255 columns and a maximum row size of 8,000 bytes."

It appears that Replication uses syscolumns.colid as the number of columns in a table, even if, as in my case, there are only 152 columns. This is the kind of arbitrary "gotcha" that makes a person sick. Our developers ignore these kinds of limitations and expect someone else to correct the problem.

|||As a follow-on, it is a good idea to have a job which checks the max(colid) on syscolumns if you add columns to your replicated tables.

No comments:

Post a Comment