Can you exclude encrypted stored procedures

tsmith

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.

Andrew P

Hey tsmith,

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