Last Security Patch

Question

Last Security Patch

Arsh

SSCertifiable

Points: 6345
More actions
September 11, 2018 at 5:53 am

#378899

Dear Experts,
Can anybody help me know how to check what the last security patch was applied to our SQL Server ? We need to check this and then apply it if not applied . Ours is SQL 2012 SP4 standard edition.
Thank You
Mohammed Arshad

Viewing 6 posts - 1 through 5 (of 5 total)

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

Sue_H SSC Guru Points: 90860 More actions · Answer 1

Arsh - Tuesday, September 11, 2018 5:53 AM
Dear Experts,
Can anybody help me know how to check what the last security patch was applied to our SQL Server ? We need to check this and then apply it if not applied . Ours is SQL 2012 SP4 standard edition.
Thank You
Mohammed Arshad

Most of the SQL Server Builds posts list the security updates. I often use this one which lists those updates:
Microsoft SQL Server Version List

Sue

Arsh SSCertifiable Points: 6345 More actions · Answer 2

Thanks Sue . So in the list , whatever appears above the patch level we are at , is what remains as unapplied so far . Is my thinking right ? thank you.

Best Regards
Arshad

Sue_H SSC Guru Points: 90860 More actions · Answer 3

Arsh - Wednesday, September 12, 2018 4:38 AM
Thanks Sue . So in the list , whatever appears above the patch level we are at , is what remains as unapplied so far . Is my thinking right ? thank you.
Best Regards
Arshad

Yes, you are correct. And the description does list if it's a security update, CU or hot fix/specific fix on the more current versions such as yours.

Sue

Arsh SSCertifiable Points: 6345 More actions · Answer 4

Sue_H - Wednesday, September 12, 2018 6:50 AM
Yes, you are correct. And the description does list if it's a security update, CU or hot fix/specific fix on the more current versions such as yours.
Sue

Thank you Sue. One more question is How do we know if its GDR or LDR. Ours is at 11.0.7001.0 ? thank you .

Best Regards....Arshad

Sue_H SSC Guru Points: 90860 More actions · Answer 5

Arsh - Sunday, September 16, 2018 2:20 AM
Thank you Sue. One more question is How do we know if its GDR or LDR. Ours is at 11.0.7001.0 ? thank you .
Best Regards....Arshad

It's in the description whether it's GDR, Security patch, CU, or fixes.

Sue