Vault 2016 – What version of SQL am I using?

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)

Happy Vaulting!