Can you exclude encrypted stored procedures
tsmith
Posts: 2
I have a database with encrypted stored procedures. I understand that I would need sysadmin access to connect to source control. Is there a way to exclude the encrypted stored procedures and connect to source control without sysadmin.
Comments
Thanks for contacting us!
You can set up a Filter to exclude them, or go to Comparison Options (both under the Setup tab) and uncheck the "Decrypt encrypted objects" option.
https://documentation.red-gate.com/display/SOC5/Exclude+objects+using+filters
and
https://documentation.red-gate.com/display/SOC5/Change+the+comparison+options
Let me know if you have any issues with that!
Warmly
Technical Sales Engineer
Redgate Software