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 for which you need to check the version
-
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 2019)
- Any service packs presently installed (for example SP1)
- Major/Minor build version (15.0.2080.9)
- Bitness (X64)
For more details regarding specific build numbers, please see the full SQL Server Versions List.
Comments