![]() SQL Server 2008 - Build information - Servicing ![]() SQL Server 2008 R2 - Build information - Installation SQL Server 2012 - Build information - Installation SQL Server 2014 - Build information - Installation SQL Server 2016 - Build information - InstallationĪzure Connect pack (.253 - May 2022) SP3 (.2 - September 2021) SP2 (.0 - April 2018) SP1 (.0 - November 2016) SQL Server 2017 - Build information - InstallationĬU (.2 - September 2022) CU31 + GDR (.1 - October 2023) SQL Server 2019 - Build information - InstallationĬU (.1 - October 2023) CU22 + GDR (.1 - October 2023) SQL Server 2022 - Build information - InstallationĬU (.4 - November 2023) CU8 + GDR (.1 - October 2023) Latest updates available for currently supported versions of SQL ServerĮach of the following links provides information for all of the applicable products and technologies. PRINT 'Full information:' + CHAR(13) + call it a new version of voodoo economics, but I'm afraid that would give witch doctors a bad name” - Geraldine A.For information about SQL Server Support lifecycle, see SQL Server support lifecycle information. PRINT 'Product Version: ' + 'Product Name: ' + 'Product Level: ' + 'Product Edition: ' + 'Product EditionID: ' + 'Update Level: ' + 'Final Version available: ' + REPLICATE('-',105) PRINT '-//Your current Microsoft SQL Server information:' SET = ISNULL(CONVERT(NVARCHAR(20),SERVERPROPERTY('ProductUpdateLevel')),'') SET = CONVERT(NVARCHAR(20),SERVERPROPERTY('ProductVersion')) SET = CONVERT(NVARCHAR(20),SERVERPROPERTY('ProductLevel')) SET = CONVERT(NVARCHAR(100),SERVERPROPERTY('Edition')) SET = CONVERT(NVARCHAR(20),SERVERPROPERTY('EditionID')) SQL> SELECT DATABASEPROPERTYEX(' your_database_name', 'Collation') SQLversion Ī full script to display the version, service pack, update level, edition and the last SP avaiable:. + CAST(SERVERPROPERTY('edition') AS VARCHAR) + ') :: ' + as 'SQL Server version' + CAST(SERVERPROPERTY('productlevel') AS VARCHAR) + ' (' + CAST(SERVERPROPERTY('productversion') AS VARCHAR) + ' - ' SQL> select can also select the individual properties: To quickly return the version information from an SQL prompt: How-to: Find the SQL Server Version and Service pack
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |