SQL Server have following data types of integer family
All members in integer family of data types except tinyint may handle negative values. So whenever using tinyint make sure that always positive value will be inserted against tinyint data type. Tinyint has values in range of 0 to 255. If an out of range value is presented then Arithmetic overflow error for data type tinyint will be generated.