Listing 2: Enabling the EKM Provider to Store Encryption Keys

-- Use EKM provider to protect encryption keys
CREATE SYMMETRIC KEY SymEncryptKey_1
AUTHORIZATION owner_name
FROM EKM_Provider_Module --Existing provider
WITH PROVIDER_KEY_NAME = 'EKM_Provider_Module_Key',
CREATION_DISPOSITION = OPEN_EXISTING
GO