Hi Tom the script that provided me still works.

USE tempdb;

GO

-- TRUNCATE TABLE dbo.Name_and_SSN

-- DROP TABLE dbo.Name_and_SSN

CREATE TABLE dbo.Name_and_SSN

(Full_Name VARCHAR(50),

CLEAR_SSN VARCHAR(12));

--point_ctl.agent_support.tax_id_number

--and point_cyp same table

INSERT INTO dbo.Name_and_SSN (Full_Name,CLEAR_SSN)

VALUES

('Egor Mcfuddle' ,'999-01-1234')

,('Frederic Mcfuddle','999-02-1234')

,('Helga Mcfuddle' ,'999-03-1234')

,('Hermine Mcfuddle' ,'999-04-1234');

/* ADD COLUMN */

--ALTER TABLE dbo.Name_and_SSN ADD ENCR_SSN VARBINARY(68) NULL;

IF NOT EXISTS (SELECT * FROM sys.symmetric_keys WHERE name = 'AES256SecureSymmetricKey')

BEGIN

CREATE SYMMETRIC KEY AES256SecureSymmetricKey

WITH ALGORITHM = AES_256

ENCRYPTION BY PASSWORD = N'StrongP@ssw0rd!';

END

OPEN SYMMETRIC KEY AES256SecureSymmetricKey

DECRYPTION BY PASSWORD = N'StrongP@ssw0rd!';

UPDATE dbo.Name_and_SSN

SET ENCR_SSN = EncryptByKey(Key_GUID('AES256SecureSymmetricKey'), convert(varbinary(68), CLEAR_SSN))

,CLEAR_SSN = '**********';

SELECT

NS.Full_Name

,NS.CLEAR_SSN

,NS.ENCR_SSN

FROM dbo.Name_and_SSN NS

SELECT

NS.Full_Name

,CONVERT(varchar(128), DecryptByKey(NS.ENCR_SSN)) as Plaintext_SSN

,DATALENGTH(NS.ENCR_SSN) AS D_LEN

FROM dbo.Name_and_SSN NS;

/* CLEAN UP */

CLOSE SYMMETRIC KEY AES256SecureSymmetricKey;

DROP SYMMETRIC KEY AES256SecureSymmetricKey;

The following script was working but now it does not work:

SELECT *

INTO POINT_CTL.AGENT_SUPPORT_ENCRYPT

FROM POINT_CTL.AGENT_SUPPORT

ALTER TABLE POINT_CTL.AGENT_SUPPORT_ENCRYPT ADD ENCR_TAX_ID_NUMBER VARBINARY(68) NULL;

IF NOT EXISTS (SELECT * FROM sys.symmetric_keys WHERE name = 'AES256SecureSymmetricKey')

BEGIN

CREATE SYMMETRIC KEY AES256SecureSymmetricKey

WITH ALGORITHM = AES_256

ENCRYPTION BY PASSWORD = N'StrongP@ssw0rd!';

END

OPEN SYMMETRIC KEY AES256SecureSymmetricKey

DECRYPTION BY PASSWORD = N'StrongP@ssw0rd!';

UPDATE POINT_CTL.AGENT_SUPPORT_ENCRYPT

SET ENCR_TAX_ID_NUMBER = EncryptByKey(Key_GUID('AES256SecureSymmetricKey'), convert(varbinary(68), TAX_ID_NUMBER))

,TAX_ID_NUMBER = '**********';

SELECT

PRIMARY_ACCOUNT_NAME

,TAX_ID_NUMBER

,ENCR_TAX_ID_NUMBER

FROM POINT_CTL.AGENT_SUPPORT_ENCRYPT

SELECT

PRIMARY_ACCOUNT_NAME

,CONVERT(varchar(128), DecryptByKey(ENCR_TAX_ID_NUMBER)) as Plaintext_TAX_ID_NUMBER

,DATALENGTH(ENCR_TAX_ID_NUMBER) AS D_LEN

FROM POINT_CTL.AGENT_SUPPORT_ENCRYPT;

/* CLEAN UP */

CLOSE SYMMETRIC KEY AES256SecureSymmetricKey;

DROP SYMMETRIC KEY AES256SecureSymmetricKey;

Do you see anything that would make the second query not work?

Thanks.