But there are plenty of other sites out there attempting to offer the same consolidated list of patches, such as: Lacking anything built into the product, I have been referencing. How can I tell if my SQL Server instances are patched? That's going to involve reading knowledge base (KB) articles and testing. If the host OS has Windows Update service running and someone has specified "Include patches for other MS products" then you might get patches installed for SQL Server.īut, if you're a professional, you're probably not interested in waiting for a patch to be listed in WSUS or you'd like to validate that the patch works for your environment. Is there native functionality to check for patches? , SERVERPROPERTY ('productlevel') AS ProductLevel SERVERPROPERTY('productversion') AS ProductVersion My preference is to use ServerProperties as I can individually identify the elements. The challenge with it is that it's a big dump of text and you have to parse that to find the relevant bits.ĭeveloper Edition (64-bit) on Windows NT 6.3 (Build 9600: ) (Hypervisor) The first is The nice thing about this is that it brings back OS level information as well. There are two different queries that I use to identify my SQL Server level. To answer in reverse order What version am I on?
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |