How to Identify Your SQL Server Version and Editio

SQL Server 2016
Version
Build
KB
Release Date
13.0.4411.0
KB3208177
January 2017
13.0.4001.0
KB3182545
November 2016
13.0.2186.6
KB3205413
November 2016
13.0.2164.0
KB3182270
September 2016
13.0.2149.0
KB3164674
July 2016
13.0.1601.5
June 2016
SQL Server 2014
Version
Build
KB
Release Date
12.0.5538.0
KB3204388
December 2016
12.0.5522.0
KB3188778
October 2016
12.0.5511.0
KB3178925
August 2016
12.0.5000.0
KB3171021
July 2016
12.0.4468.0
KB3174038
August 2016
12.0.4459.0
KB3162659
June 2016
12.0.4457.0
KB3167392
May 2016
12.0.4439.1
KB3130926
February 2016
12.0.4436.0
KB3106660
December 2015
12.0.4427.24
KB3094221
October 2015
12.0.4422.0
KB3075950
August 2015
12.0.4416.0
KB3067839
June 2015
12.0.4100.0
KB3058865
May 2015
12.0.2569.0
KB3158271
June 2016
12.0.2568.0
KB3144517
April 2016
12.0.2564.0
KB3130923
February 2016
12.0.2560.0
KB3106659
December 2015
12.0.2556.4
KB3094220
October 2015
12.0.2553.0
KB3075949
August 2015
12.0.2546.0
KB3067836
June 2015
12.0.2495.0
KB3046038
April 2015
12.0.2480.0
KB3031047
February 2015
12.0.2456.0
KB3011055
December 2014
12.0.2430.0
KB2999197
October 2014
12.0.2402.0
KB2984923
August 2014
12.0.2370.0
KB2967546
June 2014
12.0.2342.0
KB2931693
April 2014
12.0.2000.0
April 2014


SQL Server 2012
Version
Build
KB
Release Date
11.0.6579.0 
KB3205051
January 2017 
11.0.6567.0 
KB3194992
November 2016 
11.0.6544.0 
KB3180915
September 2016 
11.0.6540.0 
KB3165264
July 2016 
11.0.6537.0 
KB3152635
May 2016 
11.0.6523.0 
KB3137746
March 2016 
11.0.6518.0 
KB3123299
January 2016 
11.0.6020.0 
KB3072779
November 2015 
11.0.5655.0 
KB3165266
July 2016 
11.0.5649.0 
KB3152637
May 2016 
11.0.5646.0 
KB3137745
March 2016 
11.0.5644.2 
KB3120313
January 2016 
11.0.5641.0 
KB3098512
November 2015 
11.0.5634.0 
KB3082561
September 2015 
11.0.5623.0 
KB3072100
July 2015 
11.0.5592.0 
KB3052468
May 2015 
11.0.5582.0 
KB3037255
March 2015 
11.0.5569.0 
KB3007556
January 2015 
11.0.5556.0 
KB3002049
November 2014 
11.0.5548.0 
KB2983175
September 2014 
11.0.5532.0 
KB2976982
July 2014 
11.0.5058.0 
KB2958429
June 2014 
11.0.3492.0 
KB3052476
May 2015 
11.0.3487.0 
KB3038001
March 2015 
11.0.3486.0 
KB3023636
January 2015 
11.0.3482.0 
KB3002044
November 2014 
11.0.3470.0 
KB2991533
September 2014 
11.0.3449.0 
KB2975396
July 2014 
11.0.3431.0 
KB2954099
May 2014 
11.0.3412.0 
KB2931078
March 2014 
11.0.3401.0 
KB2917531
January 2014 
11.0.3393.0 
KB2894115
November 2013 
11.0.3381.0 
KB2874879
September 2013 
11.0.3373.0 
KB2861107
July 2013 
11.0.3368.0 
KB2833645
May 2013 
11.0.3349.0 
KB2812412
March 2013 
11.0.3339.0 
KB2790947
January 2013 
11.0.3321.0 
KB2765331
November 2012 
11.0.3000.0 
KB2674317
November 2012 
11.0.2395.0 
KB2777772
December 2012 
11.0.2383.0 
KB2758687
September 2012 
11.0.2332.0 
KB2723749
August 2012 
11.0.2325.0 
KB2703275
June 2012 
11.0.2316.0 
KB2679368
April 2012 
RTM11.0.2100.60March 2011


SQL Server 2008 R2
Version
Build
KB
Release Date
10.50.6000
KB2979597
September 2014
10.50.4319
KB2967540
June 2014
10.50.4305
KB2938478
April 2014
10.50.4302
KB2926028
February 2014
10.50.4297
KB2908087
December 2013
10.50.4295
KB2887606
October 2013
10.50.4290
KB2871401
August 2013
10.50.4286
KB2844090
June 2013
10.50.4279
KB2830140
April 2013
10.50.4276
KB2797460
February 2013
10.50.4270
KB2777358
December 2012
10.50.4266
KB2754552
October 2012
10.50.4263
KB2740411
August 2012
10.50.4260
KB2720425
August 2012
10.50.4000
KB2630458
July 2012
10.50.2868
KB2783135
December 2012
10.50.2817
KB2723743
August 2012
10.50.2822
KB2703282
June 2012
10.50.2811
KB2679367
April, 2012
10.50.2806
KB2659694
February 2012
10.50.2796
KB2633146
December 2011
10.50.2789
KB2591748
October 2011
10.50.2772
KB2567714
August 2011
10.50.2769
KB2544793
July 2011
10.50.2500
KB2527041
July 2011
10.50.1817
KB2703280
June 2012
10.50.1815
KB2679366
April 2012
10.50.1810
KB2659692
March 2012
10.50.1809
KB2633145
February 2012
10.50.1807
KB2591746
October 2011
10.50.1804
KB2567713
August 2011
10.50.1797
KB2534352
June 2011
10.50.1777
KB2507770
April 2011
10.5.1765
KB2489376
February 2011
10.5.1753
KB2438347
December 2010
10.5.1746 
KB2345451
October 2010 
10.5.1734
KB2261464
August 2010
10.5.1720
KB2072493
June 2010
10.5.1702
KB981355
May 2010
10.5.1600
April 2010


SQL Server 2008
Version
Build
KB
Release Date
10.00.6000
KB2979596
May 2014
10.00.5861
KB2958696
May 2014
10.00.5852
KB2936421
March 2014
10.00.5850
KB2923520
January 2014
10.00.5848
KB2893410
November 2013
10.00.5846
KB2880350
September 2013
10.00.5844
KB2863205
July 2013
10.00.5840
KB2834048
May 2013
10.00.5835
KB2814783
March 2013
10.00.5829
KB2799883
January 2013
10.00.5828
KB2771833
November 2012
10.00.5794
KB2738350
September 2012
10.00.5788
KB2715953
July 2012
10.00.5785
KB2696626
May 2012
10.00.5775
KB2673383
March 2012
10.00.5770
KB2648098
Januaury 2012
10.00.5768
KB2633143
November 2011
10.00.5766
KB2617146
October 2011
10.00.5500
KB2546951
October 2011
10.00.4332
KB2696625
May 2012
10.00.4330KB2673382
March 2012
10.00.4326
KB2648096
January 2012
10.00.4323
KB2617148
November 2011
10.00.4321
KB2582285
September 2011
10.00.4316
KB2555408
July 2011
10.00.4285
KB2527180
May 2011
10.00.4279
KB2498535
March 2011
10.00.4272
KB2467239
January 2011
10.00.4266
KB2289254
November 2010
10.00.4000
KB2285068
September 2010
10.00.2850
KB2582282
September 2011
10.00.2847
KB2555406
July 2011
10.00.2821
KB2527187
May 2011
10.00.2816
KB2497673
March 2011
10.00.2808
KB2467236
January 2011
10.00.2804
KB2413738
November 2010
10.00.2799
KB2279604
September 2010
10.00.2789
KB2083921
July 2010
10.00.2775
KB981702
May 2010
10.00.2766
KB979065
March 2010
10.00.2757
KB977443
January 2010
10.00.2746
KB975977
November 2009
10.00.2734
KB973602
September 2009
10.00.2723
KB971491
July 2009
10.00.2714
KB970315
May 2009
10.00.2710
KB969099
April 2009
10.00.2531
KB968369
April 2009
10.00.1835
KB979064
March 2010
10.00.1828
KB977444
January 2010
10.00.1823
KB975976
November 2009
10.00.1818
KB973601
September 2009
10.00.1812
KB971490
July 2009
10.00.1806
KB969531
May 2009
10.00.1798
KB963036
March 2009
10.00.1787
KB960484
January 2009
10.00.1779
KB958186
November 2008
10.00.1763
KB956717
November 2008
10.00.1600
August 2008


SQL Server 2005
Version
Build
KB
Release Date
9.00.5266
KB2507769
March 2011
9.00.5259
KB2489409
February 2011
9.00.5254
KB2464079
December 2010
9.00.5000
KB2463332
December 2010
9.00.4325
KB2507766
March 2011
9.00.4317
KB2489375
February 2011
9.00.4315
KB2438344
December 2010
9.00.4311
KB2345449
October 2010
9.00.4309
KB2258854
August 2010
9.00.4305
KB983329
June 2010
9.00.4294
KB980176
April 2010
9.00.4285
KB978915
February 2010
9.00.4273
KB960598
December 2009
9.00.4266
KB974648
October 2009
9.00.4230
KB972511
August 2009
9.00.4226
KB970279
June 2009
9.00.4220
KB967909
April 2009
9.00.4211
KB961930
February 2009
9.00.4207
KB959195
December 2008
9.00.4035
KB955706
December 2008
9.00.3356
KB976952
December 2009
9.00.3355
KB974647
October 2009
9.00.3330
KB972510
August 2009
9.00.3328
KB970278
June 2009
9.00.3325
KB967908
March 2009
9.00.3315
KB962970
February 2009
9.00.3301
KB958735
December 2008
9.00.3294
KB956854
October 2008
9.00.3282
KB953752
August 2008
9.00.3257
KB951217
June 2008
9.00.3239
KB949095
April 2008
9.00.3228
KB946608
February 2008
9.00.3215
KB943656
December 2007
9.00.3200
KB941450
October 2007
9.00.3186
KB939537
August 2007
9.00.3175
KB936305
June 2007
9.00.3161
KB935356
April 2007
9.00.3042
KB921896
February 2007
9.00.2153
KB918222
September 2006
9.00.2047
KB913090
April 2006
RTM
9.00.1399
November 2005


SQL Server 2000
Version
Build
KB
Release Date
8.00.2187
KB916287
October 2006
8.00.2039
May 2005
8.00.760
August 2003
8.00.532
February 2003
8.00.384
June 2001
RTM8.00.194November 2000

Comments

Post a Comment

Popular posts from this blog

How to Make Windows Photo Viewer Your Default Image Viewer on Windows 10

Image
Windows 10 uses the new Photos app as your default image viewer, but many people still prefer the old Windows Photo Viewer. You can get Photo Viewer back in Windows 10, though. It’s just hidden. If you upgrade a PC running Windows 7 or 8.1 to Windows 10, Windows Photo Viewer will be available and you can set it as your default photo viewer if you want. However, if you perform a clean installation of Windows 10—or buy a PC with Windows 10 already on it—you can’t access Photo Viewer at all. The interesting thing is that Photo Viewer is still there. It’s just hidden and you’ll have to make a couple of Registry edits to have it show up. After you do that, you can then set it as your default photo viewer. The Problem For whatever reason, Microsoft opted not to include the Registry keys that enable access to Windows Photo Viewer on Windows 10. Those keys are kept in place if you upgrade from a previous version of Windows, but they aren’t created during the installation of Windows 10. Micro...
Read more

How to configure your Outlook GMail account

Image
Configuring the Outook Gmail settings. You can configure Outlook to handle your Gmail account as a POP3 or as an IMAP account. Depending on your choice, you have to enable the related account option in your Gmail account (Gmail Settings -> Forwarding and POP/IMAP). 1. From the main Outlook window, go to Tools -> Email Accounts. 2. Select to "Add a new e-mail account" and click on Next. 3. Select POP3 or IMAP (depending on your needs) for the Outlook email account type, then click on Next. There is no need to select the IMAP type, because the Gmail web based account will anyway keep a copy of all emails, just like an IMAP account would do. You will have to specify your Outlook Gmail settings, such as your Gmail username and password, Gmail server addresses, Gmail server ports and Outlook Gmail display name. Enter your Name (it can be anything, but remember this is going to be the name/text that people will see when you will send them an email via your Outlook Gmail accou...
Read more

B1SiteUser Password Reset and Recovery

Image
During the installation of the SAP Business One server software you are asked to set a password for the B1SiteUser. The days become months and the months become years before you need to use these credentials and don't remember the password. Fear not! There is an easy solution to reset it! Open up the "Service Manager" program from the start menu. The service manager starts minimized, so it may already be running. Check the notification area of your Windows taskbar for the blue and red icon. Double click the icon to bring up the settings window. Select the "License Manager" from the dropdown in the second box from the top. You want to click the "Settings" button. Now we see the license manager's settings. Find the button on the bottom of the window called "Configure Security". Resetting the B1SiteUser Password This will bring you to a webpage on your server. There might be some issues with web browsing on your server depending on security ...
Read more