While most of the stored procedures under the Utilities schema are rarely used, and focus on conditions that aren't usually expected to occur, the ConsolidateVersions script is expected to be used as part of regular maintenance, and could cause significant data loss if it doesn't operate as expected. For this reason, the SQL unit tests should be expanded to cover the ConsolidateVersions stored procedure, even if they don't cover any other other objects under Utilities.
While most of the stored procedures under the
Utilitiesschema are rarely used, and focus on conditions that aren't usually expected to occur, theConsolidateVersionsscript is expected to be used as part of regular maintenance, and could cause significant data loss if it doesn't operate as expected. For this reason, the SQL unit tests should be expanded to cover theConsolidateVersionsstored procedure, even if they don't cover any other other objects underUtilities.