Re: Best way to Encrypt a feild in a production db?

Hi

http://msdn2.microsoft.com/en-us/library/ms181860(SQL.90).aspx ---Enscrypt
http://blogs.msdn.com/lcris/---Enscrypt


"Hulicat" <dennis_A_white@xxxxxxxxx> wrote in message
news:05bdf5ba-ffee-4e40-950c-a951d46b917e@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
I have a db that is storing SSNs in clear text, I have been trying
some things in dev with mixed results.

Is there a way to encypt this data without having to pass a cert to
insert or select the data in the feilds?

I want to avoid changing all of the associated stored procedures if
it's possible.

Thanks,


.