Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

error on usp_SSAJ_SQL_Server_System_Report Expand / Collapse
Posted Wednesday, April 18, 2012 9:24 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, June 17, 2016 6:36 AM
Points: 25, Visits: 217
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)
Post #1285725
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse