Hi all,
Having a bit of a problem and can't figure out if there is a option to solve my issue.
In some of our servers we implemented automatic certificate signing of code which is done through a ddl trigger. All works great as expected.
however now when we do a schema compare on SSDT and we have any change to a proc (which on the database is signed by default), schema compare decides to add a "add signature... to object" as part of the alter script.
As this will be invalid, and the users doing the development or deployment won't even have the required permissions to do a ADD SIGNATURE to any object I need to find a way of preventing this on the automatic script generation.
Alternative, which I do not like, is to have a post generation script to parse the alter script and remove the offending lines.
Any ideas welcome - and if I am blind I would gladly have someone tell me which option to tick/untick.
Thanks in advance.