Sql server 2008 r2 standard edition version number

It is always recommended that you update to the latest service pack and security update for the version of SQL Server that you are using, however this is even more important if you are running SQL Server R2 SP1. A quick way to check your version number is to just connect to the database in SSMS and the version number will be shown in the object explorer.

This page last updated March 15, Checking the Version Number A quick way to check your version number is to just connect to the database in SSMS and the version number will be shown in the object explorer. Contact us today for your free 30 minute consultation. We are ready to help! Download this page in PDF format. This website uses cookies to improve your experience. What happens if I don't install a download manager? Why should I install the Microsoft Download Manager?

In this case, you will have to download the files individually. You would have the opportunity to download individual files on the "Thank you for downloading" page after completing your download. Files larger than 1 GB may take much longer to download and might not download correctly. You might not be able to pause the active downloads or resume downloads that have failed. This download comes as a pre-configured VHD. Details Note: There are multiple files available for this download.

Once you click on the "Download" button, you will be prompted to select the files you need. File Name:. Date Published:. File Size:. System Requirements Supported Operating System. Install Instructions 1. This is because the discovery report will have run before the PolyBase feature was added. We recommend that you refresh the Summary. Refer to the Rlauncher. For Linux servers, the following command returns a list of all mssql-specific installed packages, together with their version numbers:.

The version number of the mssql-server-extensibility package version is the SQL Server version of the Machine Learning Services feature.

The version number of the mssql-mlservices-packages-r or mssql-mlservices-packages-py refers to each language package file. Cumulative update CU : A roll-up update that contains all previous critical on-demand hotfixes to date. Additionally, a CU contains fixes for issues that meet the hotfix acceptance criteria. These criteria may include the availability of a workaround, the effect on the customer, the reproducibility of the problem, the complexity of the code that must be changed, and other topics.

Hotfix: A single, cumulative package that includes one or more files that are used to address a problem in a product and are cumulative at the binary and file level. A hotfix addresses a specific customer situation and may not be distributed outside the customer's organization.

RTM: Usually means "release to manufacturing". In the context of a product such as SQL Server, it indicates that no service packs or hotfixes were applied to the product. RTW: Usually means "release to web". It indicates a package that was released to the web and made available to customers for downloading. Service pack: A tested, cumulative set of all hotfixes, security updates, critical updates, and updates. Service packs may also contain additional fixes for problems that are found internally since the release of the product and a limited number of customer-requested design changes or features.

Description of the standard terminology that is used to describe Microsoft software updates. Software release life cycle. SQL Server documentation.

SQL Server product information center. Skip to main content. This browser is no longer supported. Download Microsoft Edge More info. Contents Exit focus mode. Is this page helpful?

Please rate your experience Yes No. Any additional feedback? Note The version information and edition information are in the same output string. Note The output of this query has been enhanced to show additional information, as documented in the blog post article, What build of SQL Server are you using?

Note The output of this query has been enhanced to show additional information. Note Each of these methods may indicate that the version of the full-text search component is either RTM or a version that is earlier than the current version of the database component.