Thursday 2 June 2011

SQL SERVER HISTORY


SQL SERVER RELASE History
S.NOSQl Server Version YearOperating System Support
1Sql Server 4.2 199216-bit os/2.13 relase
2Sql Server 4.2 1993windows NT
3Sql Server 6.01995windows NT
4Sql Server 6.51996windows NT
5Sql Server 7.01998windows NT
6Sql Server 20002000windows NT
7Sql Server 20052005windows NT
8Sql Server 20082008windows NT
9Sql Server 2008 R22008windows NT
    
SQL SERVER Version History
S.NOselect @@version numberSQL Server and Service Pack Version 
16.50.201SQL Server 6.5 RTM 
26.50.213SQL Server 6.5 with Service Pack 1 
36.50.240SQL Server 6.5 with Service Pack 2 
46.50.258SQL Server 6.5 with Service Pack 3 
56.50.281SQL Server 6.5 with Service Pack 4 
66.50.415SQL Server 6.5 with Service Pack 5 
76.50.416SQL Server 6.5 with Service Pack 5a 
87.00.623SQL Server 7.0 (MSDE 1.0 RTM) 
97.00.699SQL Server 7.0 with Service Pack 1 
107.00.842SQL Server 7.0 with Service Pack 2 
117.00.961SQL Server 7.0 with Service Pack 3 
127.00.1063SQL Server 7.0 with Service Pack 4 
138.00.194SQL Server 2000 RTM 
148.00.384SQL Server 2000 with Service Pack 1 
158.00.534SQL Server 2000 with Service Pack 2 
168.00.760SQL Server 2000 with Service Pack 3 
178.00.760SQL Server 2000 with Service Pack 3a 
188.00.2039SQL Server 2000 with Service Pack 4 
199.00.1399SQL Server 2005 RTM 
209.00.2047SQL Server 2005 with Service Pack 1 
219.00.3042.00SQL Server 2005 with Service Pack 2 
229.00.3042.01SQL Server 2005 with Service Pack 2a 
239.00.3050SQL Server 2005 with Service Pack 2 with Hot Fix 
2510.00.1075.23SQL Server 2008 November CTP 
2610.00.1600SQL Server 2008 RTM 
2710.00.2531SQL Server 2008 with Service Pack 1 

1 comment:

  1. for effective administrative tasks on SQL server or to clear any doubts approach
    sql server specialist

    ReplyDelete