NUMERIC_ROUNDABORT specifies the level of error reporting that has been generated when an expression being rounded has caused loss of precision.
NUMERIC_ROUNDABORT
SET NUMERIC_ROUNDABORT ON