#Microsoft sql server 2012 enterprise edition update
Starting with SQL Server 2014 RTM Cumulative Update 10 and SQL Server 2014 Service Pack 1 Cumulative Update 3, additional properties have been added to ServerProperty statement. For more information, see the following topic in SQL Server Books Online SERVERPROPERTY (Transact-SQL). This method also works for SQL Azure Database instances. If your application requires individual property strings, you can use the SERVERPROPERTY function to return them instead of parsing the results. The SERVERPROPERTY function returns individual properties that relate to the version information, although the function combines the output into one string. This entry provides 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. The entries may resemble the following: 22:31:33.50 Server Microsoft SQL Server 2008 (SP1). By default, the error log is located at Program Files\Microsoft SQL Server\MSSQL.n\MSSQL\LOG\ERRORLOG and ERRORLOG.n files. Method 2: Look at the first few lines of the Errorlog file for that instance. 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 1: Connect to the server by using Object Explorer in SQL Server Management Studio. To determine the version of SQL Server, you can use any of the following methods. "Latest" = During the past 12 months Determine which version and edition of SQL Server Database Engine is running 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. To find the edition of your SQL Server instance, you can use one of the procedures in Method 2 through Method 5 in the Determine which version and edition of SQL Server Database Engine is running section.įor information about SQL Server Support lifecycle, see SQL Server support lifecycle information. To learn what a specific version number of SQL Server maps to, or to find the KB article information for a specific cumulative update package or a service pack, search for the version number in the SQL Server Complete Version list tables. Original product version: SQL Server Original KB number: 321185 SummaryĪ downloadable version of an Excel workbook that contains all the build versions together with their current support lifecycle stage for 2005 through the current version is available. This article lists various builds or updates that are available for different versions of SQL Server and describe the procedures to determine the version of SQL Server that is running on a given system.
0 kommentar(er)
