Friday, 20 April 2012

Microsoft SQL Server 2008 Service Pack 2(10.00.1600.22) right now we are using in sreego

You can write in Query window to find which version of SQL Server 2008 is running ?

SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
(or)
SELECT  @@Version
Microsoft SQL Server 2008 Service Pack 2 (SP2) is now available for download.

http://www.microsoft.com/download/en/details.aspx?id=12548

SQL Server 2008SQL Builds Version


Supported Link - To Check All version in SQL server 2008&2005&2000.

http://sqlsecurity.com/FAQs/SQLServerVersionDatabase/tabid/63/Default.aspx


Patch LevelPSS OnlyLinkBuildSorted By Build In Descending OrderVersion
2008 R2 SP1 + Cumulative Update 3GO2,78910.50.2789
2008 R2 SP1 + Cumulative Update 2GO2,77210.50.2772
2008 R2 SP1 + Cumulative Update 1GO2,76910.50.2769
2008 R2 + SP1GO2,50010.50.2500
2008 R2 + SP1 CTPGO2,41810.50.2418
2008 R2 + Cumulative Update 9GO1,80410.50.1804
2008 R2 + Cumulative Update 8GO1,79710.50.1797
2008 R2 + Q2494086GO1,79010.50.1790
2008 R2 + Cumulative Update 7GO1,77710.50.1777
2008 R2 + Cumulative Update 6GO1,76510.50.1765
2008 R2 + Cumulative Update 5GO1,75310.50.1753
2008 R2 + Cumulative Update 4GO1,74610.50.1746
2008 R2 + Cumulative Update 3GO1,73410.50.1734
2008 R2 + Cumulative Update 2GO1,72010.50.1720
2008 R2 + Cumulative Update 1GO1,70210.50.1702
RTMN/A1,60010.50.1600.1
RC 0N/A1,45010.50.1450.3
SQL Server 2008 Builds
 Patch LevelPSS OnlyLinkBuildSorted By Build In Descending OrderVersion
2008 + Service Pack 3GO5,50010.00.5500
2008 SP2 + Cumulative Update 6GO4,32110.00.4321
2008 SP2 + Cumulative Update 5GO4,31610.00.4316
2008 SP2 + Q2494094GO4,31110.00.4311
2008 + Cumulative Update 4 for SP2GO4,28510.00.4285
2008 + Cumulative Update 3 for SP2GO4,27910.00.4279
2008 + Cumulative Update 2 for SP2GO4,27210.00.4272
2008 + Cumulative Update 1 for SP2GO4,26610.00.4266
2008 SP2 + Q2494089GO4,06410.00.4064
2008 + Service Pack 2GO4,00010.00.4000
2008 + Cumulative Update 16 for SP1GO2,85010.00.2850
2008 + Cumulative Update 15 for SP1GO2,84710.00.2847
2008 SP1 + Q2494100GO2,84110.00.2841
2008 + Cumulative Update 14 for SP1GO2,82110.00.2821
2008 + Cumulative Update 13 for SP1GO2,81610.00.2816
2008 + Cumulative Update 12 for SP1GO2,80810.00.2808
2008 + Q2413738GO2,80410.00.2804
2008 + Cumulative Update 10 for SP1GO2,79910.00.2799
2008 + Cumulative Update 9 for SP1GO2,78910.00.2789
2008 + Cumulative Update 8 for SP1GO2,77510.00.2775
2008 + Cumulative Update 7 for SP1GO2,76610.00.2766
2008 + Q978839GO2,76010.00.2760
2008 SP1 + Q978791GO2,75810.00.2758
2008 + Cumulative Update 6 for SP1GO2,75710.00.2757
2008 + Cumulative Update 5 for SP1GO2,74610.00.2746
2008 + Q976761GO2,74010.00.2740
2008 + Cumulative Update 4 for SP1GO2,73410.00.2734
2008 + Cumulative Update 3 for SP1GO2,72310.00.2723
2008 + Cumulative Update 2 for SP1GO2,71410.00.2714
2008 + Q970507GO2,71210.00.2712
2008 + Cumulative Update 1 for SP1GO2,71010.00.2710
2008 + Service Pack 1GO2,53110.00.2531
2008 + Cumulative Update 10GO1,83510.00.1835
2008 + Cumulative Update 9GO1,82810.00.1828
2008 + Cumulative Update 8GO1,82310.00.1823
2008 + Q973601GO1,81810.00.1818
2008 + Cumulative Update 6GO1,81210.00.1812
2008 + Cumulative Update 5GO1,80610.00.1806
2008 + Cumulative Update 4GO1,79810.00.1798
2008 + Cumulative Update 3GO1,78710.00.1787
2008 + Q958186 (Cumulative HF2, available by request.)GO1,77910.00.1779
2008 + Q958611GO1,77110.00.1771
2008 + Q956717GO1,76310.00.1763
2008 + Q957387GO1,75510.00.1755
2008 + Q956718GO1,75010.00.1750
2008 RTMGO1,60010.00.1600.22
2008 February CTPGO1,30010.00.1300.13
2008 July CTP (requires Virtual Server 2005 R2)GO1,04910.00.1049.14
2008 June CTPGO1,01910.00.1019.17