Microsoft SQL server internal database version
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.