2270617 - Installation fails at 99% processing SP_A_DROP_INDEXES.mssql

Installation fails at 99% while processing SP_A_DROP_INDEXES.mssql

The following error is displayed:

---------------------------
setup
---------------------------
Error processing SQL statements:
SQLStatement: CREATE PROC [SP_A_DROP_INDEXES] @TableName VARCHAR(255)
 AS
 BEGIN
  SET NOCOUNT ON
  IF ( SELECT OBJECT_ID(@TableName) ) IS NULL
   BEGIN
    PRINT 'Table does not exist'
    RETURN
   END
  DECLARE @SQL VARCHAR(8000),
          @Columnlist VARCHAR(8000),
          @Message VARCHAR(8000),
     ...

ADO Error:
Code = 0x80040e14
(Not a native OS error)
ADO Code meaning = IDispatch error #3092
Source = Microsoft OLE DB Provider for ODBC Drivers
Description = [Microsoft][ODBC SQL Server Driver][SQL Server]Must declare the scalar variable "@sql".

ADO Error 1 of 2
  Number      = 0x80040e14
  Source      = Microsoft OLE DB Provider for ODBC Drivers
Description = [Microsoft][ODBC SQL Server Driver][SQL Server]Must declare the scalar variable "@sql".
SQLState    = 37000
  NativeError = 137

ADO Error 2 of 2
  Number      = 0x80040e14
  Source      = Microsoft OLE DB Provider for ODBC Drivers
Description = [Microsoft][ODBC SQL Server Driver][SQL Server]Must declare the scalar variable "@sql".
SQLState    = 37000
  NativeError = 137

---------------------------
OK  
---------------------------

• Afaria 7.0
• SQL Server database
• Case sensitive server collation

install, fail, crash, error , KBA , MOB-AFA , Afaria , Problem