About--sql Server version

SQL SERVER Build Number:

SQL Server Version	Internal Database Version
SQL Server 2014	98|
SQL Server 2012	706
SQL Server R2	665
SQL Server 2008	661
SQL Server 2005 sp2+ with vardecimal enabled	612
SQL Server 2005	611
SQL Server 2000	539
SQL Server 7	515

Database version:

Pictures from a yellow xx blog (xx do not do too much explanation here)

--========================================================

Add:

1. You can use RESTORE HEADERONLY from DISK = N ' F:\dba1.bak ' to see which version of the server the backup originated from.

--========================================================

About--sql Server version