SQL2005 Encryption problem

I am getting null values when i decrypt the encrypted column in my table. As of now, i have no idea where i went wrong. Here is the sql statement i used: if not exists (select * from sys.symmetric_keys where symmetric_key_id=101) create master key encryption by password =abc123456&*(‘ go create certificate myportal with subject =’Credit […]