Top 10 SQL Compare Tips. Watch now.

Module Signing Support?

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 = '[email protected]'
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:

Answers

Sign In or Register to comment.