How to Find Version Information in SQL Server?

Hello everyone,

In this article, I will give information about how to learn version information in SQL Server.

In SQL Server, in some cases, you may want to learn the version information.

There are several ways to find out.

The first way

SELECT @@VERSION

is to run the statement.

How to Find Version Information in SQL Server?

As you can see, the version information has arrived.

The second way is to right click on Object Explorer while in SQL Server Management Studio and select Properties.

How to Find Version Information in SQL Server?

After clicking Properties, you can see the version information in the section below.

How to Find Version Information in SQL Server?

The third way is

SELECT SERVERPROPERTY('ProductVersion')

is to run the code in SQL Server Management Studio.

How to Find Version Information in SQL Server?

  • 8 = SQL 2000
  • 9 = SQL 2005
  • 10 = SQL 2008 (and 10.5 = SQL 2008R2)
  • 11 = SQL 2012
  • 12 = SQL 2014
  • 13 = SQL 2016
  • 14 = SQL 2017
  • 15 = SQL 2019

You can find which version of SQL Server you are using from the version numbers above.

Good luck to everyone in business and life.

243 Views

Yavuz Selim Kart

I try to explain what I know in software and database. I am still improving myself by doing research on many programming languages. Apart from these, I am also interested in Graphic Design and Wordpress. I also have knowledge about SEO and Social media management. In short, I am a determined person who likes to work hard.

You may also like...

Don`t copy text!