Get-Hotfix command – check installed hotfixes

Get-Hotfix command - check installed hotfixes

Very short and simple post however, oh so important especially when a software vendor requires using specific version / hotfix.

First we need to import the SQLPS module and connect to the instance (Optionally you could cycle though your list of instances, or use the SQL server browser service to detect all available instances. Samples can be found within the following post)

Get-Hotfix command

To retrieve the version (Major.Minor.Build.BuildMinor) just call;

To get the product level for the instance of SQL Server;

For retrieving all applied hotfixes, execute the following;

Additionl information about the Get-Hotfix command can be found here http://technet.microsoft.com/en-us/library/hh849836.aspx. Or provide the ID if you are looking for a specific hotfix:

Post Navigation