Stored Procedure is Missing

Overview

Sometimes a missing stored procedure prevents the database update script from working. An error message will indicate that the script either cannot create or cannot alter the stored procedure, which will start with sp or spcp. An empty version of the stored procedure can be created, allowing the script to proceed. Substitute the name of the missing stored procedure with the spcpUpdateItemMaster value.

Procedure

1. Open SQL Server Management Studio
2. Navigate to Databases > (your database) > Programmability > Stored Procedures
3. Click the New Query button in the upper left portion of the window
4. Enter the following text in the field that appears:
   create procedure spcpUpdateItemMaster as
   
5. Click the Execute button to run the command
   A window below the command will display a message that should read: Command(s) completed successfully
6. Open SalesPad, and the database update will modify the empty procedure.