Options

Module Signing Support?

howarthcdhowarthcd Posts: 70 Bronze 3
in SQL Compare
Hi, does SQL Compare check databases for differences in relation to module signing?

I ask because comparisons between a database and a scripts folder don't appear to have been identifying that a particular stored procedure in a database had been deployed without being signed, yet the script file contains a statement to sign the stored procedure by a certificate.

e.g.

ADD SIGNATURE TO [dbo].[MyProcedure]
BY CERTIFICATE [MyCertificate]
WITH PASSWORD = 'p@ssw0rd'
GO

I've not seen any options to enable or disable module signing checks so I was wondering whether it was supported.

Thanks
Chris
Tagged:
· Share on Twitter

Answers

Sign In or Register to comment.