error on usp_SSAJ_SQL_Server_System_Report

  • 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)

Viewing 0 posts

You must be logged in to reply to this topic. Login to reply