v2.2.0

This minor release addresses the following two items:

• #13 Tweaks to object existence check
  • The script now checks for the existence of dbo.SqlServerVersions using the OBJECT_ID function
  • The existence check specifies the schema
  • GO statements have been added between logical batches
• #15 Clean up workaround for 2014 SP3
  • For a while, the build number for SQL Server 2014 SP3 wasn't listed on the main support page. A workaround was added to account for this. Now that SP3 is listed, the workaround code has been removed to keep things tidy (thanks again, @reharmsen!)

v2.1.1

This hotfix release addresses the following two issues:

• #9 Error running program
  • Prevent the application crashing due to a typo on the support site (replaces Septmeber with September)
• #11 Problem with NULL in MainstreamSupportEndDate
  • Hardcode the support dates for SQL Server 2014 SP3 since they are still not up on the support site

v2.1.0

This minor release addresses the following two requests:

• #5 Add option to update/refresh data rather then dropping table
  • The generated script no longer drops and recreates the version table. Instead it deletes all the rows and reloads it (creating the table if it doesn't exist initially)
• #6 NULL value's not allowed
  • The application has been enhanced to support running in non-US-English locales

v2.0.0

Fixes:

#1 Output results to .sql file
#2 Add a primary key to SqlServerVersions table

This is a breaking change, as the script contents is saved to a file instead of being displayed in the command prompt. Thus the version bump to 2.0.0.

v1.0.0

This is the initial release of the SQL Server Version Script app. It includes two versions:

• SqlServerVersionScript-NetCoreSC-win64.zip
  • a self-contained .NET Core app (.exe) that runs on 64-bit Windows
  • run this by extracting the zip and running GetSqlServerVersionInfo.exe
• SqlServerVersionScript-NetCoreFDD-win64.zip
  • a (much smaller) Framework-dependent deployment of the .NET Core app (.dll) that run on 64-bit Windows
  • requires .NET Core to be present on the machine
  • this can be run from the command line by extracting the zip and running dotnet GetSqlServerVersionInfo.dll