1

Good Morning Experts,

I had applied CU7(cumulative update 7) to SQL Server 2012 EE SP1 instance. After applying, when i queried SELECT SERVERPROPERTY('ProductUpdateLevel'), it is displaying as NULL instead of CU7. Could you please help.

1
  • Can you tell me what is returned with SELECT SERVERPROPERTY('ProductUpdateReference')? Commented Oct 18, 2016 at 2:24

2 Answers 2

5

As per https://msdn.microsoft.com/en-us/library/ms174396.aspx the property ProductUpdateLevel

Applies to: SQL Server 2012 through current version in updates beginning in late 2015.

SQL Server 2012 SP1 CU7 is from November 2013, and so not sufficiently current.

There is no SP1 cumulative update that would support pulling that information. You would need to move to Service Pack 2 with CU9 at the least.

As a side note, SQL Server 2012 SP1 was no longer supported as of July 2015. Service Pack 2 will stop being supported in January of 2017 (as detailed in the Microsoft Lifecycle Policy). You should look to upgrade to Service Pack 3 as soon as possible to remain in support.

1

https://blogs.sentryone.com/aaronbertrand/new-serverproperty-options-to-help-phase-out-version/ Looking at that SP2 CU8 is the minimum requirement

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.