Test the code coverage for the encrypted procedures

Navya Phutane

Hi,
I have a stored procedure which is encrypted, when i test the code coverage using the DLM tool, it throws an exception.
Is there any alternative for testing the encrypted procedures?

Rob C

Hi,

This is the forum for our SQL Compare tool - ideally this topic would go in either the SQL Test or DLM Automation forums.

Having said that, I believe you're talking about Ed Elliot's SQL Cover tool - Ed uploaded a fix to SQL Cover that skips over encrypted stored procedures rather than crashing. You won't get code coverage for encrypted procedures but there is now a "Warnings" property on the results showing any encrypted procs that are skipped.

You'll need to download the new version from here - https://the.agilesql.club/SQLCover/download.php

I hope this helps.