Undercover Catalogue 0.2 Hox Fix 2 and SQL2008r2/2008/possibly 2005 Compatibility Patch RELEASED

Undercover Catalogue 0.2.2

It looks like a bug has crept it’s way into the Undercover Catalogue.

When running with certain versions of DBA Tools, a number of the modules will fail to collect when the Interrogation script is run (this is down to my sloppy coding, no fault of the great guys at DBA Tools). This hot fix will solve that problem.

The hot fix can be downloaded from GitHub, this will need to be run against your central monitoring instance as well as all target instances.

https://github.com/SQLUndercover/UndercoverToolbox/blob/master/SQLUndercoverCatalogue/UndercoverCatalogue%200.2.2%20Hotfix.sql

SQL 2008r2/2008/possibly 2005 Compatibility Patch (unsupported)

The Databases and Availability Groups modules will fail when run against versions of SQL Server prior to SQL 2012.

We’re going to stand by our decision to only support SQL 2012 onwards but to help out you guys who are still running 2012 and 2012r2 (this may also work on 2005 but it’s not been tested), we’ve put together a compatibility patch for you.

The patch should be applied ONLY to those non-supported instances.

https://github.com/SQLUndercover/UndercoverToolbox/blob/master/SQLUndercoverCatalogue/UndercoverCatalogue%20SQL2008%20Compatibility.sql