How to check Munis Version a Database is installed with

Description of Issue

Need to identify what version of Munis the database is running on

Context
  • Munis
  • Database
  • SSMS
  • SQL
  • Version
Cause

This article is to assist with identifying and confirming the SQL Server System Revision for the Database a user is working in. 

Resolution
  1. Open SSMS
  2. Connect to the customer's Database server
  3. Expand Databases
  4. Right-Click the customer's database
  5. Select New Query
  6. Paste the following command into the query window: SELECT sys_rev FROM spsysrec
  7. Click Execute in the top left
  8. Database version will be displayed in the query results pane
Additional Information