CREATE PROCEDURE [dbo].[DeleteEncryptedContent]
AS
-- Remove the encryption keys
delete from keys where client >= 0
-- Remove the encrypted content
update datasource
set CredentialRetrieval = 1, -- CredentialRetrieval.Prompt
    ConnectionString = null,
    OriginalConnectionString = null,
    UserName = null,
    Password = null

GO
GRANT EXECUTE ON  [dbo].[DeleteEncryptedContent] TO [RSExecRole]
GO