QUery to get Cumulative package (CU#)

Question

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 1

SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

Use this excellent site to look up which CU matches the build:

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Steve Dell SSCarpal Tunnel Points: 4623 More actions · Answer 2

SO we do not have any Query for CU # ? that i can run on Server instead of looking it manually ?

Thanks in Advance

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 3

RamSteve (2/6/2014)
SO we do not have any Query for CU # ? that i can run on Server instead of looking it manually ?
Thanks in Advance

Nope. You can add a table that lists all the different build numbers and their CU level, so you can look it up when you query.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP