CREATE MASTER KEY ENCRYPTION BY PASSWORD = '123'

CREATE CERTIFICATE DEK_EncCert WITH SUBJECT = 'DEK Encryption Certificate'


USE Crypt
go
CREATE DATABASE ENCRYPTION KEY WITH ALGORITHM = AES_256
ENCRYPTION BY SERVER CERTIFICATE DEK_EncCert

ALTER DATABASE Crypt  
SET ENCRYPTION ON;