October 8, 2016 at 5:24 pm
Comments posted to this topic are about the item SQL 2012: SERVERPROPERTY
October 10, 2016 at 7:52 am
Quite an interesting question for practical use, thanks to GP Van Eron.
I understand that if on SQL Server 2012 was the last installation
Cumulative Update #14 for SQL Server 2012 SP2, the results of this code would be:
SELECT SERVERPROPERTY('PRODUCTUPDATELEVEL') .... result CU14
SELECT SERVERPROPERTY('ProductUpdateReference') .... result KB3180914
October 10, 2016 at 11:49 am
Thank you for the feedback. If I wrote the question again I would focus a bit more on learning SERVERPROPERTY options rather than nuisances of patching levels. But also want to encourage users to keep up with CU releases. On top of break/fixes sometimes nifty new features are included.
October 10, 2016 at 12:53 pm
GP Van Eron (10/10/2016)
Thank you for the feedback. If I wrote the question again I would focus a bit more on learning SERVERPROPERTY options rather than nuisances of patching levels. But also want to encourage users to keep up with CU releases. On top of break/fixes sometimes nifty new features are included.
Thank You for Your post. You're right about the SERVERPROPERTY can be a lot to learn,
I counted 44 of arguments, so it's actually as a little book about SQL Server...
Best Regards.
October 11, 2016 at 1:39 am
Is it ironic that by running the SQL in SMSS I proved that I had a patched version that provided the "latest Cummulative Update (CU) installed" so chose that as my answer?
Glad the server is patched but lost a point on QotD :crying:
Thanks for the question.
Gaz
-- Stop your grinnin' and drop your linen...they're everywhere!!!
October 11, 2016 at 10:58 am
Bah! If I had any control I'd give you an extra point for being a pro-active DBA
October 13, 2016 at 7:43 am
Very nice question, I had to examine all the instances i work on to check your answer is correct.
Thanks
Igor Micev,My blog: www.igormicev.com
October 25, 2016 at 2:21 am
Gary Varga (10/11/2016)
Is it ironic that by running the SQL in SMSS I proved that I had a patched version that provided the "latest Cummulative Update (CU) installed" so chose that as my answer?Glad the server is patched but lost a point on QotD :crying:
Thanks for the question.
Same here... :doze:
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy