The process of determining your version of SQL Server requires the following two components
- SQL Server Management Studio
- The ability to connect to the database engine of the SQL instance you wish to check the version of
Process
-
Open SQL Server Management Studio, and connect to the database engine of the instance that you wish to check the version of
-
Perform the following three steps;
- Click the New Query button (or, hit CTRL+N on your keyboard).
- Type select @@version
- Click the Execute button in the ribbon, or press F5 on your keyboard
-
The results pane will appear, showing you:
- Your version of SQL (Microsoft SQL Server 2012)
- Any service packs presently installed (SP1)
- Major/Minor build version (11.0.3128.0)
- Bitness (X64)
For more details regarding specific build numbers, please see the full SQL Server Versions List.
Comments