Article Creation Fails with Msg 21395

Question

Article Creation Fails with Msg 21395

Viewing 2 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

VG-327096 Newbie Points: 9 More actions · Answer 1

Here is how colid values get fragmented.

When you delete a column from a table, the corresponding record is deleted from syscolumns. When you later add a column to the same table, a new record is added to syscolumns with the new colid value (for some reason, the old one is not reused).

As far as how to solve it, I am still looking for a solution.

BR,

VG

mike-306849 SSChasing Mays Points: 607 More actions · Answer 2

VG, thanks for the reply. Yes after some further research I discovered that we have dropped and receated a column on that table repeatedly through a series of code updates. The column in question was a computed column from a UDF. That UDF is dropped and recreated along with several views referring to the table. The only method we have found to deal with this is to copy all the data out, drop the objects tied to it, and then drop the table and recreate everything.