we have a Sql server that has been executing this stored procedure daily
It has been successful for about a year.
A couple of days ago it started failing.
The error is
Conversion failed when converting the varchar value '1,000' to data type int.
No changes have been made to the SP .
I believe the statement it is failing on is
REVERSE (SUBSTRING (REVERSE (CONVERT (VARCHAR (15), CONVERT (MONEY, ROUND (BS.backup_size/1048576.0, 0)), 1)), 4, 15)) AS backup_size_mb
Any ideas on why this would suddenly start happening?
The version of sql server is
Microsoft SQL Server 2008 (SP2) - 10.0.4266.0 (Intel X86) Nov 6 2010 12:40:17 Copyright (c) 1988-2008 Microsoft Corporation Enterprise Edition on Windows NT 6.0 <X86> (Build 6002: Service Pack 2)