SQL Server Performance Forum – Threads Archive

Arithmetic overflow error for data type tinyint

Any idea why am I getting below error during trans. replication. I got this from snapshot agent error details:
"Arithmetic overflow error for data type tinyint, value = -1." Thanks,
Jon M

---

Check if your source column is tinyint or something else. If not, sync your destination column with the source column. The only valid data in a tinyint is 0-255.

---

Thanks for your reply Argyle. Although, I think it’s more on my total field size for each record. After deleting some unnecessary fields, my trans replication went through. Jon M

---

]]>