Author Archives: Joel Dykstra

How to determine your Vista Version and Database Version

Using the Application

  1. Open Vista
  2. Click the “Help” drop down menu in the top left hand corner of the application
  3. Select “About Vista”
    • Determing Vista Version 1
  4. The following dialog should appear
    • Determing Vista Version 2
  5. In this case
    1. The Vista Version is 2.60.05
    2. The Database Version is 2.60
  6. Note: the first 3 numbers of the Vista Version and Database Version will be the same if they are in sync.  If they are out of sync there may be errors or unexpected behavior.

For Database Administrators – Using SQL Server Management Studio

  1. Log into the Vista (or otherwise named database).
  2. Run the following query against the database.

    [sql]SELECT TOP 1 * FROM DBVERSION ORDER BY VersNum DESC[/sql]

    VersNum gives the database version. For example, if VersNum has value 260, then the database has been updated to version 2.60.