sql server replication: 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.

Can you post the schema of the table here?

Are you from Alberta? I was born there:)

--
Hilary Cotter

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com



[quoted text, click to view]

some names have been changed to protect the innocent, i hope this is
useful to you

no, I've never been to Alberta ;)

Field Type Length Precision
field1 money 19
field2 nvarchar 50
field3 nvarchar 50
field4 nvarchar 50
field5 money 19
field6 datetime 23
field7 money 19
field8 datetime 23
field9 float 53
field10 money 19
field11 money 19
field12 money 19
field13 money 19
field14 nvarchar 50
field15 numeric 18
field16 smallint 5
field17 smallint 5
field18 money 19
field19 money 19
field20 int 10
field21 money 19
field22 nvarchar 50
field23 money 19
field24 money 19
field25 nvarchar 50
field26 nvarchar 50
field27 money 19
field28 money 19
field29 nvarchar 50
field30 nvarchar 50
field31 nvarchar 50
field32 ntext 1073741823
field33 datetime 23
field34 datetime 23
field35 datetime 23
field36 ntext 1073741823
field37 float 53
field38 nvarchar 50
field39 ntext 1073741823
field40 nvarchar 50
field41 ntext 1073741823
field42 nvarchar 50
field43 nvarchar 50
field44 nvarchar 50
field45 datetime 23
field46 nvarchar 50
field47 nvarchar 50
field48 nvarchar 50
field49 ntext 1073741823
field50 money 19
field51 datetime 23
field52 float 53
field53 money 19
field54 money 19
field55 money 19
field56 money 19
field57 nvarchar 50
field58 nvarchar 50
field59 money 19
field60 smallint 5
field61 money 19
field62 smallint 5
field63 money 19
field64 money 19
field65 money 19
field66 money 19
field67 money 19
field68 datetime 23
field69 float 53
field70 money 19
field71 money 19
field72 money 19
field73 money 19
field74 numeric 18
field75 numeric 18
field76 money 19
field77 smallint 5
field78 money 19
field79 smallint 5
field80 money 19
field81 money 19
field82 int 10
field83 money 19
field84 numeric 18
field85 numeric 18
field86 numeric 18
field87 money 19
field88 nvarchar 50
field89 numeric 18
field90 nvarchar 50
field91 ntext 1073741823
field92 ntext 1073741823
field93 nvarchar 50
field94 nvarchar 50
field95 datetime 23
field96 nvarchar 50
field97 ntext 1073741823
field98 datetime 23
field99 money 19
field100 money 19
field101 money 19
field102 datetime 23
field103 float 53
field104 money 19
field105 money 19
field106 money 19
field107 money 19
field108 numeric 18
field109 numeric 18
field110 money 19
field111 smallint 5
field112 money 19
field113 smallint 5
field114 money 19
field115 money 19
field116 int 10
field117 money 19
field118 nvarchar 50
field119 nvarchar 50
field120 nvarchar 50
field121 nvarchar 50
field122 ntext 1073741823
field123 ntext 1073741823
field124 nvarchar 50
field125 nvarchar 50
field126 ntext 1073741823
field127 numeric 18
field128 money 19
field129 ntext 1073741823
field130 datetime 23
field131 ntext 1073741823
field132 nvarchar 50
field133 nvarchar 50
field134 nvarchar 50
field135 nvarchar 50
field136 varchar 50
field137 datetime 23
field138 nvarchar 50
field139 nvarchar 50
field140 nvarchar 50
field141 ntext 1073741823
field142 nvarchar 50
field143 nvarchar 50
field144 nvarchar 50
field145 ntext 1073741823
field146 nvarchar 50
field147 ntext 1073741823
field148 ntext 1073741823
field149 ntext 1073741823
field150 ntext 1073741823
field151 datetime 23
field152 ntext 1073741823
field153 datetime 23
field154 datetime 23
field155 nvarchar 50
field156 nvarchar 50
field157 nvarchar 50
field158 numeric 18
field159 nvarchar 50
field160 nvarchar 50
field161 ntext 1073741823
field162 int 10
field163 bit 1
field164 text 2147483647
field165 bit 1
field166 ntext 1073741823
field167 nvarchar 50
field168 nvarchar 128