dimanche 28 juin 2015

T-SQL error Could not find stored procedure

Just wondering any one can help me with this T-SQL script, error code below. As my expertise in SQL is very limited I am not sure if this means that store procedure is missing or something actually wrong with the script.

 EXEC isp_ALTER_INDEX 
    @dbName = 'MODEV', 
    @statsMode = 'SAMPLED', 
    @defragType = 'REBUILD',
    @minFragPercent = 5,
    @maxFragPercent = 100,
    @minRowCount = 1000000,
    @logHistory = 1,
    @sortInTempdb = 1

Error

Executed as user: Could not find stored procedure 'isp_ALTER_INDEX'. [SQLSTATE 42000] (Error 2812). The step failed.

Aucun commentaire:

Enregistrer un commentaire