By Kim Hyde
Trying to find which Microsoft version your Vault is using, particularly if you are not sure if it’s a full or Express version is not obvious. Just viewing a list of installed applications via Control Panel > Programs and Features doesn’t really help!
Read on to following how to find out quickly and easily by using SQL Studio…
Step-1 is to establish if you have the relevant SQL Studio installed, they are available in both `Full’ (often installed by default if you are using a full version) and `Express’ versions; a simple Google search will suffice to find you a download for the right variant and year release.
Once installed, run `SQL Server Management Studio’ via Windows Start Button > All Programs etc...
Once connected, select the `New Query’ button
In the Query window, type select @@Version (note that @@Version appears in a magenta colour), then press the Execute button.
In the Results window below, right click over the information created and paste the results into a Word file. (see the resultant text below).
It’s as simple as that … the Express version is listed (as supplied via the Autodesk media)
…May the 4th be with you
Microsoft SQL Server 2012 - 11.0.5343.0 (X64)
May 4 2015 19:11:32
Copyright (c) Microsoft Corporation
Express Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)