Version of MDB

Document ID : KB000053391
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

How to find the version of MDB in ITCM?

Solution:

Open SQL Management Studio and run the following query against the MDB:

select * from mdb

(OR)

Open command prompt and type the following commands:

osql -S localhost -d mdb -E -e -b -Q "exit(select mdbmajorversion, mdbminorversion, buildnumber from mdb)"

If 'osql' is unavailable you can use 'isql' with the same syntax.

isql -S localhost -d mdb -E -e -b -Q "exit(select mdbmajorversion, mdbminorversion, buildnumber from mdb)"