Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  • Verify that your SQL Servers instances are patched to the same level and/or the appropriate level.
  • Identify whether any SQL Server instances are running unsupported versions of SQL Server (or versions whose support is about to expire).
  • Use quick links to Microsoft Knowledge Base articles to get more information about applied hotfixes and new hotfixes.
  • Keep up with the latest patches by downloading the most recent list compiled by IderaIDERA.

By default, Patch Analyzer connects to the specified SQL Server instances using the credentials of your currently logged on Windows account.

...

To use Patch Analyzer:

  1. Open the Idera IDERA SQL Admin Toolset Launchpad, and then click Patch Analyzer.
  2. Specify the SQL Server instance or server group whose SQL Server versions you want to check. To specify multiple SQL Servers, separate each instance name with a semicolon.
  3. Click Load Version Information. Review the results and note the highlighted versions that are no longer supported or are soon becoming unsupported.
  4. If you want to group the results by SQL Server version, click Show Groups on the View menu.
  5. If you want to see more information about a hotfix that was applied to your SQL Server instance, select the instance from the results list, and then click View the Microsoft Knowledge Base Article.
  6. If you want to see which new hotfixes are available, select the SQL Server instance you want to update from the results list, and then click View Available Updates.
  7. If you want to save the results , copy the list to clipboard, or save the results as an XML or CSV file.

...

SQL Admin Toolset delivers 24 essential administration tools. Learn more > >