Microsoft SQL Server support lifecycle; 321185 How to determine the version and edition of SQL Server and its components; The script to determine which version and edition of SQL Server Database Engine is running. 957826 The builds for all SQL Server versions; 3177534 How to obtain the latest service pack for SQL Server 2016; 822499 Naming schema and Fix area descriptions for SQL Server. SQL Server 2019 makes it easier to manage a big data environment. It provides key elements of a data lake—Hadoop Distributed File System (HDFS), Spark, and analytics tools—deeply integrated with SQL Server and fully supported by Microsoft. Easily deploy using Linux containers on a Kubernetes-managed cluster. The SQL Server versions you use remain in support by Microsoft. SQL Server supports replication between the two versions of SQL Server. For more information, see SQL Server replication backward compatibility. For SQL Server 2016 and prior, support for each SQL version and service pack follows the Microsoft Lifecycle Policy. Support for a. The current version is Microsoft SQL Server 2017, released October 2, 2017. The RTM version is 14.1709.3807.1. SQL Server 2019 has been released as a community technology preview and is slated for release to manufacturing in the second half of 2019. We are using a SQL Server Data-tier application (dacpac or DAC pack) and I'm having a hard time finding the current version of the database. Is there a way to obtain the current version using any of.
What you'll love about SQL Server 2019
SQL Server 2019 brings innovative security and compliance features, industry-leading performance, mission-critical availability, and advanced analytics to all your data workloads, now with support for big data built-in.
Intelligence over any data
SQL Server is a hub for data integration. Deliver transformational insights over structured and unstructured data with the power of SQL Server and Spark.
Choice of language and platform
Build modern applications with innovative features using your choice of language and platform. Now on Windows, Linux, and containers.
Industry-leading performance
Take advantage of breakthrough scalability, performance, and availability for mission-critical, intelligent applications, data warehouses, and data lakes.
Advanced security features
Protect data at rest and in use. SQL Server has been the least vulnerable database over the last 8 years in the NIST vulnerabilities database.
Make faster, better decisions
Power BI Report Server gives your users access to rich, interactive Power BI reports, and the enterprise reporting capabilities of SQL Server Reporting Services.
Active6 months ago
What are the possible ways to determine the deployed SQL Server version?
I’ve tried to do it using the SQL Server software. I want to do it using a command line SQL statement.
dakab
3,65988 gold badges3030 silver badges4949 bronze badges
Yameen BashirYameen Bashir
5 Answers
Following are possible ways to see the version:
Method 1: Connect to the instance of SQL Server, and then run the following query:
An example of the output of this query is as follows:
Method 2: 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.
Method 3: Look at the first few lines of the Errorlog file for that instance. By default, the error log is located at Program FilesMicrosoft SQL
ServerMSSQL.nMSSQLLOGERRORLOG and ERRORLOG.n files. The entries may resemble the following:
As you can see, this entry gives all the necessary information about the product, such as version, product level, 64-bit versus 32-bit, the edition of SQL Server, and the OS version on which SQL Server is running.
Method 4: Connect to the instance of SQL Server, and then run the following query:
Note This query works with any instance of SQL Server 2000 or of a later version
OGHaza
4,56866 gold badges1919 silver badges2828 bronze badges
ImranImran
3,76822 gold badges1616 silver badges3939 bronze badges
Gives 8.00, 9.00, 10.00 and 10.50 for SQL 2000, 2005, 2008 and 2008R2 respectively.
Also, Try the system extended procedure Lingasamy SakthivelLingasamy Sakthivel
xp_msver . You can call this stored procedure like
8,48399 gold badges4545 silver badges8686 bronze badges
TL;DR
This uses SQLCMD (comes with SQL Server) to connect to the local server instance using Windows auth, throw an error if a version check fails and return the
@@ERROR as the command line ERRORLEVEL if >= 16 (and the second line goes to the :ExitFail label if the aforementioned ERRORLEVEL is >= 1).
Watchas, Gotchas & More Info
For SQL 2000+ you can use the SERVERPROPERTY to determine a lot of this info.
While SQL 2008+ supports the
ProductMajorVersion & ProductMinorVersion properties, ProductVersion has been around since 2000 (remembering that if a property is not supported the function returns NULL ).
If you are interested in earlier versions you can use the
PARSENAME function to split the ProductVersion (remembering the 'parts' are numbered right to left i.e. PARSENAME('a.b.c', 1) returns c ).
Also remember that
PARSENAME('a.b.c', 4) returns NULL , because SQL 2005 and earlier only used 3 parts in the version number!
So for SQL 2008+ you can simply use:
For SQL 2000-2005 you can use:
(the
PARSENAME(...,0) is a hack to improve readability)
So a check for a SQL 2000+ version would be:
Current Microsoft Sql Server Version
This is a lot simpler if you're only only interested in SQL 2008+ because
SERVERPROPERTY('ProductMajorVersion') returns NULL for earlier versions, so you can use:
And you can use the
ProductLevel and Edition (or EngineEdition ) properties to determine RTM / SPn / CTPn and Dev / Std / Ent / etc respectively.
FYI the major SQL version numbers are:
Current Microsoft Sql Version List
And this all works for SQL Azure too!
EDITED:You may also want to check your DB compatibility level since it could be set to a lower compatibility.
Current Microsoft Sql Version History
AndrewDAndrewD
R.AlonsoR.Alonso
Current Ms Sql Version
Here is what i have done to find the version:just write
SELECT @@version and it will give you the version.
Imad UllahImad Ullah
Microsoft Sql Server 2012 Current VersionNot the answer you're looking for? Browse other questions tagged sql-server-2008version or ask your own question.Comments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |