August 21, 2013 at 8:22 am
Hi,
I am trying to find out which cumulative update is currently installed in SQL server 2008 R2.
I can get the service pack and build number using this:- select @@version which gives me:-
Microsoft SQL Server 2008 R2 (SP2) - 10.50.4000.0 (X64) Jun 28 2012 08:36:30 Copyright (c) Microsoft Corporation Developer Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) (Hypervisor)
I have searched using 10.50.4000.0 but I can't get the cumulative update.
August 21, 2013 at 7:11 pm
Have you checked this?
http://www.sqlservercentral.com/articles/SQL+Server+2008+R2/70092/
August 22, 2013 at 2:52 am
Even though I have installed CU1 as a test, it still shows the build as 10.50.4000.
The build number with CU1 installed should have changed to: 10.50.4260.
I am using EXEC xp_msver to get these details.
I have restarted the server as well but still get the same build number and File version number.
August 22, 2013 at 5:59 pm
Oh, you didn't mention that you already added CU1 in your original post. Ok, is it possible that you may not have installed it properly?
Did you have any errors? I don't know if it generates a log for a Cumulative update.
Most people normally don't do cumulative updates unless it fixes something that is impacting them and they can't wait for the next service pack. I wait for service packs.
You can also see the version of SQL from the GUI - on your instance name when you expand it, you will see the version, also you can right click the instance name and click properties.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply