Thanks for the reply;

GilaMonster;

I want to encrypt the entire DB so that if someone steal the DB, then they are not able to attach it or restore it;

thanks for your helps.

Thanks for your reply.

Thanks steve.

SQL Server 2000 is a statndalone with default instance. Thank you.

I mean, when the users use sql analyser, they should see encrypted data, they should not be seening the actual data.

Thanks for your helps. I want to encrypt/decrypt only at the Server side only and few columns in the SQL Tables. I do not care about the decrypted data going...

thanks steve,

I want to encrypt only certain columns in SQL Database. Without require any change to the applications; how I can encrypt and decrypt the columns within SQL server side...