How do I find my SQL Server version in Windows 10?

Question

How to tell what version of Microsoft SQL Server you are running? One simple way to do this is to run SELECT @@version. Another option is to right click on the SQL Server instance name in SSMS and select Properties. You can also use the SERVERPROPERTY function to get details about the version of SQL Server.

How do I check Microsoft SQL Server version?

Method 1: Connect to the server by using Object Explorer in SQL Server Management Studio. After Object Explorer is connected, it will show the version information in parentheses, together with the user name that is used to connect to the specific instance of SQL Server.

How do I know if SQL Server is installed Windows 10?

Click Start, point to All Programs, point to Microsoft SQL Server, point to Configuration Tools, and then click SQL Server Configuration Manager. If you do not have these entries on the Start menu, SQL Server is not correctly installed. Run Setup to install the SQL Server Database Engine.

What is the current SQL Server version?

The current version is Microsoft SQL Server 2019, released November 4, 2019.

Is SQL Server part of Windows 10?

Yes indicates that SQL Server 2016 on Windows 10 is supported.

Expert · Answer