Wednesday, March 21, 2012

Replication problem after reduce no of columns to less than 254

There was a replication problem between db1 and db3. The scenario is that a
table was added with more than 254 nos. of columns. An error
[Error 2757: RAISERROR failed due to invalid parameter substitution(s) for
error 20068, severity 16, state 1]
is prompted during the creation of publication for the replication.
Therefore, the new added columns are deleted. However, there is another
error [Error 220: Arithmetic overflow error for data type tinyint, value =
256.]
is prompted when the publication for the replication was created again.
How to fix this error?
David NG
can I see the schema for this reduced table? How many columns did it have
originally?
http://www.zetainteractive.com - Shift Happens!
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
"David NG" <David NG@.discussions.microsoft.com> wrote in message
news:384758F8-4985-4566-B8C0-7532A0C7DFC3@.microsoft.com...
> There was a replication problem between db1 and db3. The scenario is that
> a
> table was added with more than 254 nos. of columns. An error
> [Error 2757: RAISERROR failed due to invalid parameter substitution(s) for
> error 20068, severity 16, state 1]
> is prompted during the creation of publication for the replication.
>
> Therefore, the new added columns are deleted. However, there is another
> error [Error 220: Arithmetic overflow error for data type tinyint, value =
> 256.]
> is prompted when the publication for the replication was created again.
> How to fix this error?
> David NG
>

No comments:

Post a Comment