Undercover Catalogue 0.2.1, Fixes An Issue With The Recording Of Unicode And MAX Datatype Lengths

Please see https://sqlundercover.com/undercover-catalogue-0-2/ for full details on the Undercover Catalogue and how to obtain it.

We’ve spotted an issue where unicode datatypes were having their size recorded as the data length rather than character count in the ‘Tables’ module. Another issue affected any MAX datatypes which were having their length mis-recorded.

Version 0.2.1 fixes both these issues.

Upgrading From 0.2.0

If you’re currently running v0.2.0, you can upgrade simply by running ‘UndercoverCatalogue 0.2.1 Hotfix.sql’ against all servers where the Catalogue is installed.

You’ll also need update your Interrogator script to the lastest ‘CatalogueInterrogation.ps1’ script.

Upgrading From 0.1.0

If you’re upgrading from v0.1.0 you’ll need to run the full ‘UndercoverCatalogue Setup.sql’ script.

You’ll also need update your Interrogator script to the latest ‘CatalogueInterrogation.ps1’ script.

All scripts are available from our GitHub site.