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)"