kpwimberger (1/17/2013)
But doesn't this mean I need the password inside EVERY proc I write that touches an encrypted column? isn't this adding insecurity into the system? What if the password needs to change, it will be scattered throughout the system.Iam sure there must be a way to do this without explicitly calling the password.
e4d4 is on the right track, can you post the code you used to create the certificate?
If you specify encrypt by password the password must be specified each and every time you open the cert. Omit the encryption by password and its automatically opened by the DMK
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉