error 220: arithmetic overflow in publication 1

[MikeT]

I am unable to alter or create a publication that uses a particular table. If I try to create a publication with this table or if I try to add or remove a column from my existing publication that uses this table, i get the error message "error 220: arithmetic overflow error for datatype tinyint, value = -9."

There are no fields of "tinyint" type in this table. In fact, I've looked at all the tinyint field values throughout the entire datbase (system tables included) and none of them have -9 for a value.

I am able to add or remove columns from other articles in this publication.

Anyone know some things I can check? Thanks.

 

[ptheriault]

try running DBCC CHECKTABLE on the table in question. Does it find any errors on the table.

- Paul
- If at first you don't succeed, find out if the loser gets anything.

 

[MikeT]

thanks for the reply, no errors were reported.

 

[ptheriault]

Can you create a copy of this table and add that to your publication?

- Paul
- If at first you don't succeed, find out if the loser gets anything.

 

[MikeT]

Yes, I am able to add a copy of the table to the publication.

 

[ptheriault]

Then I would make sure my copy has all the indexes and triggers and re-name the old table and keep the copy.

- Paul
- If at first you don't succeed, find out if the loser gets anything.