Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Replication Error 21395 Column ID >255

Author  Topic 

netjam
Starting Member

37 Posts

Posted - 2008-10-24 : 05:50:57
One of the tables had 257 columns, I removed number of columns down to 254
However while adding this Article I am getting an error Column ID > 255
I had this issue in a past but I cannot remember solution.
Something to do with Indexes or Statistic

Any ideas?

beyonder422
Posting Yak Master

124 Posts

Posted - 2008-11-07 : 15:50:08
Having the same problem here.

Error 21395: This column cannot be included .... column ID is greater than 255.

Went in and looked at sysobjects and syscolumns values, but not sure what I am looking for.

Not seeing anything helpful about the error.

Table only has 181 columns. Column names are fine. Data is fine.

We scripted out the table and created an exact copy, imported the data into the new table and replicated it with no problem.

Any input appreciated for future reference.


---------------------
I do not define what is obvious...
Go to Top of Page
   

- Advertisement -