1. Home
  2. Knowledge Base
  3. On-premise/Customer-Hosted Server
  4. SQL
  5. Stored procedure can only be executed at the ad hoc level

Stored procedure can only be executed at the ad hoc level

This article applies if you are receiving the following error when upgrading your EIOBoard database:

Stored procedure ‘sys.sp_dbcmptlevel’ can only be executed at the ad hoc level.

Note:Ā Because you are editing the EIOBoard database, you must be very careful to not change any other settings or database tables that may impair EIOBoardā€™s functionality. If you would like EIOBoardā€™s support team to take care of this database work for you, feel free to purchase a Block of Support. EIOBoardā€™s support team can do all the necessary work for you over a web conference! For details, visitĀ EIOBoard Training and Consulting.

Here are the steps needed to resolve this issue and to successfully upgrade your EIOBoard database.

  1. Open up SQL Management Studio.
  2. Browse to the EIOBoard database, right click the database, and select New Query.
  3. Run the following script. Be sure to change the text DBNAMEĀ to the name of your database (by default, the name is “SolutionSavant”).
    Exec sp_dbcmptlevel @dbname = ‘DBNAME’, @new_cmptlevel = 90 ;
  4. Once you have run this script, wait for it to complete successfully.
  5. Run the EIOBoard Intranet Installer as usual. The EIOBoard upgrade should now run as normal.
Was this article helpful?

Related Articles

Need Support?

Can't find the answer you're looking for?
Contact Support