How to find the SQL Server version

In this article, we will explore how to find the SQL Server translation details with assorted methods.

Introduction

One of the crucial responsibilities of a database administrator is to keep the SQL Server initiation up-to-date. The installation list for the update process can be created from the following items :

  • Service packs
  • Cumulative updates
  • General Distribution Releases (GDR)
  • Version upgrades

On the other hand, the SQL Server edition upgrade might be taken to the agenda by the database administrators to obtain modern features. such as, for some cases, we might be faced an write out that needs to determine the service carry level of the SQL Server. For this reason, the database administrator may always need to know the version and version details of the SQL Server with wholly details or at least know how to obtain it. immediately, we will go through different methods on how to find translation details of the SQL Server .

Finding the SQL Server version with SSMS

SQL Server Management Studio ( SSMS ) is a identical helpful and handy tool in order to manage the SQL Server installations. besides, when we connect to any example of the SQL Server with the aid of SSMS, we can see that the product version is shown in the Object Explorer tab between two parentheses. This fix of numbers defines the product translation of the SQL Server. now, we will learn how to convert the version details from this meaningless laid of numbers :
To find SQL Server version To find SQL Server version
In the above screenshot, the product interpretation is specified as 15.0.1400.75 but this set of numbers is not much meaningful and therefore we should convert it to more meaningful and utilitarian information. The first two-digits ( 15 ) define the numeral definition of the SQL Server product name. The following table shows SQL Server versions against the product name so that we can find out the merchandise appoint rather promptly :

SQL Server Product Version SQL Server Product Name
15.0.xxxx.xx SQL Server 2019
14.0.xxxx.xx SQL Server 2017
13.0.xxxx.xx SQL Server 2016
12.0.xxxx.xx SQL Server 2014
11.0.xxxx.xx SQL Server 2012
10.5.xxxx.xx SQL Server 2008 R2
10.0.xxxx.xx SQL Server 2008
9.0.xxxx.xx SQL Server 2005
8.0.xxxx.xx SQL Server 2000

however, we achieved the product name alone with the help of the first two-digits but we need more details about the SQL Server case. The remaining numbers ( 1400.75 ) provide aid to uncover service pack level and accumulative update grade details. In order to find out these details, we can look at the BuildNumbers website so that we can well figure out all the detail information about the SQL Server case :
SQL Server version number details.SQL Server version number details.
For our example, the adaptation count is 15.0.1400.75 and it comes up to SQL Server 2019 CTP 2.4. ( Community Technology Preview 2.4 ) which was released on March 26, 2019, as shown in the mesa. At the same time, this table helps us to discover the latest version of the SQL Servers .

Finding the SQL Server version with query

We can use the @ @ VERSION function to find out all version details of the SQL Server case. The @ @ VERSION function returns a one-line drawstring output and this output besides provides all the necessary information about the SQL Server .
The output of this function will be involved in the keep up information :

  • SQL Server Version
  • Processor Architecture
  • SQL Server Build Date
  • Copyright Statement
  • SQL Server Edition
  • Operating System Version

now, we will run the trace question and get the details of the SQL Server :

1

SELECT

@

@

VERSION

AS

‘SQL Server Version Details’

@@VERSION function output and SQL Server version details @@VERSION function output and SQL Server version details
“ Microsoft SQL Server 2019 ( CTP2.4 ) – 15.0.1400.75 ( X64 ) Mar 16 2019 11:53:26 Copyright ( C ) 2019 Microsoft Corporation Enterprise Evaluation Edition ( 64-bit ) on Windows 10 Pro 10.0 (Build 17763: )”

As we can see, the end product of the @ @ VERSION function returns sufficiently data about SQL Server. We will convert this data into a more meaningful form with the aid of the following mesa :

SQL Server version Microsoft SQL Server 2019 ( CTP2.4 ) -15.0.1400.75
Processor architecture X64
SQL Server build date Mar 16 2019 11:53:26
Copyright statement Copyright ( C ) 2019 Microsoft Corporation
SQL Server edition Enterprise Evaluation Edition ( 64-bit )
Operating system version Windows 10 Pro 10.0 (Build 17763: )

Finding the SQL Server version in the SQL Server error logs

SQL Server error log charge records user-defined events and specific system events so that we can use it to troubleshoot SQL Server issues. other than this, the SQL Server error log file helps us to determine the version details of the SQL Server. In the first few lines of the error log file, it contains detailed information about the version data about the SQL Server. By nonpayment, the error log is placed under “ Program Files\Microsoft SQL Server\MSSQL.n\MSSQL\LOG\ ”. The other option which helps us to determine the mistake log file localization is the SERVERPROPERTY function. The following question returns the location of the error log file :

1

SELECT

SERVERPROPERTY

(

‘ErrorLogFileName’

)

AS

‘Error log file location’

SQL Server errorlog file pathSQL Server errorlog file path
now, we will open the erroneousness logarithm file in the specify localization :
Find SQL Server version with help of the errorlog fileFind SQL Server version with help of the errorlog file
The entrance of the mistake log file provides all details about the SQL Server build. The other method acting to read the error log is sp_readerrorlog operation and the first cable of the resultset indicates the SQL Server case details :
sp_readerrorlog procedure resultset sp_readerrorlog procedure resultset

Conclusion

In this article, we mentioned how to find out the SQL Server interpretation with the different methods and besides learned how to convert it to more meaningful information. After reading this article, you should be able to distinguish which SQL Server product translation number corresponds precisely to which particular definition and other detail information.

source : https://thefartiste.com
Category : Tech

About admin

I am the owner of the website thefartiste.com, my purpose is to bring all the most useful information to users.

Check Also

articlewriting1

Manage participants in a zoom meeting webinar

Call the people who attend the meet as follows Alternate host host Who scheduled the …

Leave a Reply

Your email address will not be published.