Tuesday, April 28, 2015

SQL VERSION INFORMATION

SQL VERSION INFORMATION

SQL Server 2012 version information

The following table lists the major releases of SQL Server 2012:
Release
Product Version
SQL Server 2012 Service Pack 1
11.00.3000.00
SQL Server 2012 RTM
11.00.2100.60

SQL Server 2008 R2 version information

The following table lists the major releases of SQL Server 2008 R2:
Release
Product version
SQL Server 2008 R2 Service Pack 2
10.50.4000.0
SQL Server 2008 R2 Service Pack 1
10.50.2500.0
SQL Server 2008 R2 RTM
10.50.1600.1

SQL Server 2008 version information

The following table lists the major releases of SQL Server 2008:
Release
Product version
SQL Server 2008 Service Pack 3
10.00.5500.00
SQL Server 2008 Service Pack 2
10.00.4000.00
SQL Server 2008 Service Pack 1
10.00.2531.00
SQL Server 2008 RTM
10.00.1600.22

SQL Server 2005 version information

The following table lists the major releases of SQL Server 2005:
Release
Product version
SQL Server 2005 Service Pack 4
9.00.5000.00
SQL Server 2005 Service Pack 3
9.00.4035
SQL Server 2005 Service Pack 2
9.00.3042
SQL Server 2005 Service Pack 1
9.00.2047
SQL Server 2005 RTM
9.00.1399

SQL Server 2000 version information

The following table lists version number of the Sqlservr.exe file: 


Release
Product version
SQL Server 2000 Service Pack 4
8.00.2039
SQL Server 2000 Service Pack 3
8.00.760
SQL Server 2000 Service Pack 3
8.00.760
SQL Server 2000 Service Pack 2
8.00.534
SQL Server 2000 Service Pack 1
8.00.384
SQL Server 2000 RTM
8.00.194

No comments: