After installing MP-5, on logging into database receive error:
Engine : Monitor Enterprise
Number : -2147217900
Description : Procedure or function sp_SaveSelf has too many arguments
specified.
Location : Monitor/DataAccess/RunBuiltCommand (sp_SaveSelf)
Source : Microsoft OLE DB Provider for SQL Server
The information in the article refers to:
Monitor-Pro MP-5
Applies to:
| Product: | MP-5 |
| Reported Version: | MP5.0.5 |
| Applies to: | MP5.0.5 |
| Area of effect | Login |
Synopsis
This error refers to a missing stored procedure. This is required for version 5.0.5 and is included in the upgrade from 5.0.3 or 4 to 5.0.5.
Solution
Re-run the upgrade. If you do not have it then click here to download it (9mb). Run the setup. When you reach the options page, choose to upgrade only the database. If your database is on your desktop PC then leave the Windows Authentication box checked, and type (local) - with the brackets, as your server name. You will not need a password. If the database is on a server, then you will need the server name, as well as a user name and password for the server (your Monitor-Pro login will not work). Proceed to complete the upgrade.
If this does not resolve your issue, please contact support