| SQL SERVER RELASE History | |||
| S.NO | SQl Server Version | Year | Operating System Support |
| 1 | Sql Server 4.2 | 1992 | 16-bit os/2.13 relase |
| 2 | Sql Server 4.2 | 1993 | windows NT |
| 3 | Sql Server 6.0 | 1995 | windows NT |
| 4 | Sql Server 6.5 | 1996 | windows NT |
| 5 | Sql Server 7.0 | 1998 | windows NT |
| 6 | Sql Server 2000 | 2000 | windows NT |
| 7 | Sql Server 2005 | 2005 | windows NT |
| 8 | Sql Server 2008 | 2008 | windows NT |
| 9 | Sql Server 2008 R2 | 2008 | windows NT |
| SQL SERVER Version History | |||
| S.NO | select @@version number | SQL Server and Service Pack Version | |
| 1 | 6.50.201 | SQL Server 6.5 RTM | |
| 2 | 6.50.213 | SQL Server 6.5 with Service Pack 1 | |
| 3 | 6.50.240 | SQL Server 6.5 with Service Pack 2 | |
| 4 | 6.50.258 | SQL Server 6.5 with Service Pack 3 | |
| 5 | 6.50.281 | SQL Server 6.5 with Service Pack 4 | |
| 6 | 6.50.415 | SQL Server 6.5 with Service Pack 5 | |
| 7 | 6.50.416 | SQL Server 6.5 with Service Pack 5a | |
| 8 | 7.00.623 | SQL Server 7.0 (MSDE 1.0 RTM) | |
| 9 | 7.00.699 | SQL Server 7.0 with Service Pack 1 | |
| 10 | 7.00.842 | SQL Server 7.0 with Service Pack 2 | |
| 11 | 7.00.961 | SQL Server 7.0 with Service Pack 3 | |
| 12 | 7.00.1063 | SQL Server 7.0 with Service Pack 4 | |
| 13 | 8.00.194 | SQL Server 2000 RTM | |
| 14 | 8.00.384 | SQL Server 2000 with Service Pack 1 | |
| 15 | 8.00.534 | SQL Server 2000 with Service Pack 2 | |
| 16 | 8.00.760 | SQL Server 2000 with Service Pack 3 | |
| 17 | 8.00.760 | SQL Server 2000 with Service Pack 3a | |
| 18 | 8.00.2039 | SQL Server 2000 with Service Pack 4 | |
| 19 | 9.00.1399 | SQL Server 2005 RTM | |
| 20 | 9.00.2047 | SQL Server 2005 with Service Pack 1 | |
| 21 | 9.00.3042.00 | SQL Server 2005 with Service Pack 2 | |
| 22 | 9.00.3042.01 | SQL Server 2005 with Service Pack 2a | |
| 23 | 9.00.3050 | SQL Server 2005 with Service Pack 2 with Hot Fix | |
| 25 | 10.00.1075.23 | SQL Server 2008 November CTP | |
| 26 | 10.00.1600 | SQL Server 2008 RTM | |
| 27 | 10.00.2531 | SQL Server 2008 with Service Pack 1 | |
This Blog provide you the knowledge regarding DBMS and RDBMS.Specially for SQL SERVER and Oracle. Thanks A Lot .......for your cooperation and support.
Thursday, 2 June 2011
SQL SERVER HISTORY
Subscribe to:
Post Comments (Atom)
for effective administrative tasks on SQL server or to clear any doubts approach
ReplyDeletesql server specialist