While perform some task on Microsoft Sql Server, you may see the different version number in the error message as follow:
The database ‘WHDdb’ cannot be opened because it is version 852. This server supports version 782 and earlier. A downgrade path is not supported.
In this article we will list the internal database version for all SQL server versions.
| SQL Server Version | Internal Database Version |
|---|---|
| SQL Server 2016 | 852 |
| SQL Server 2014 | 782 |
| SQL Server 2012 | 706 |
| SQL Server 2008 R2 | 660/661 |
| SQL Server 2008 | 655 |
| SQL Server 2005 | 611/612 |
| SQL Server 2000 | 539 |
| SQL Server 7 | 515 |
Hope this will help you to know the exact version for your SQL server in case if you receive any message related to SQL server internal database version.
This post first appeared on Web Hosting Blog - Web Hosting Discussion, please read the originial post: here
