Encryption

Do you guys encrypt data on SQL 2K? If you do, you prefer server side
(data sent to server and SQL encrypts data before saving) or client side
(data encrypted before sent to server? We are looking at encryption to
protect sensitive data such as SSN's and still don't know what is the right
way to start and what is the pros and cons for each approach? What tools do
you guys use for this purpose? Thanks for your input.
Check the encryption section in this FAQ:
http://www.sqlsecurity.com/DesktopDefault.aspx?tabid=22
Some of the third party product sites have white papers as
well.
-Sue
On Mon, 7 Mar 2005 10:10:21 -0800, "ME" <ME@.hotmail.com>
wrote:

>Do you guys encrypt data on SQL 2K? If you do, you prefer server side
>(data sent to server and SQL encrypts data before saving) or client side
>(data encrypted before sent to server? We are looking at encryption to
>protect sensitive data such as SSN's and still don't know what is the right
>way to start and what is the pros and cons for each approach? What tools do
>you guys use for this purpose? Thanks for your input.
>
|||You might investigate the Microsoft Crypto API. The Interop.Capicom dll is
included in the Platform SDK
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:3mls21drp8ss6noflbg3ujao1dt2l9gle0@.4ax.com... [vbcol=seagreen]
> Check the encryption section in this FAQ:
> http://www.sqlsecurity.com/DesktopDefault.aspx?tabid=22
> Some of the third party product sites have white papers as
> well.
> -Sue
> On Mon, 7 Mar 2005 10:10:21 -0800, "ME" <ME@.hotmail.com>
> wrote:
right[vbcol=seagreen]
do
>
sql