SQL Server SPROC SIGNATURE CERTIFICATE

This query will give you a list of all stored procedures in the database that have a certificate.

SELECT
	*
FROM
	[sys].[procedures]
LEFT JOIN
	[sys].[crypt_properties] ON
	[sys].[crypt_properties].[major_id] = [sys].[procedures].[object_id]
WHERE
	[major_id] IS NOT NULL

Select allOpen in new window

Thanks.  It seems that the stored procedures were signed with a certificate.  Would backing up the database cause not being able to log in from the website?

I am having issues connecting to the database.  I wrote a small app to test.  I can connect to the database but when I perform a select statment against a table I get:

"The SELECT permission was denied on the object 'xxxxxxxxx', database 'xxxxxx', schema 'dbo'."}
    [System.Data.SqlClient.SqlException]: {"The SELECT permission was denied on the object 'xxxxxxx', database 'xxxxx', schema 'dbo'."}
    Data: {System.Collections.ListDictionaryInternal}
    HelpLink: null
    HResult: -2146232060

>> It seems that the stored procedures were signed with a certificate.  Would backing up the database cause not being able to log in from the website?

Need more info, do you mean to say that you were having issues after taking a backup of the database..
If so, then it shouldn't..

If you wish to backup and restore the database in another server, then you would need to do the following:
1. Create the same certificate in the destination db server.
2. Take the backup from Source DB server.
3. Restore it in Destination DB Server.

Kindly try recreating the certificate if you have made any changes recently..

FYI, please find the steps to do the backup or restore of a database with Encryption enabled.
https://solutioncenter.apexsql.com/backup-and-restore-sql-server-backup-encryption/