Data Encryption

Can MS SQL 2005 encryp data?
How to do that?Hi
Yes SQL 2005 does have methods to encrypt data using functions such as
EncryptByKey, EncryptByPassPhrase, EncryptByAsmKey or EncryptByCert. there
are also DDL to create certificates or keys to use in these functions. For an
overview see
http://www.microsoft.com/technet/itshowcase/content/sqldatsec.mspx
Example at http://msdn2.microsoft.com/en-us/library/ms179331.aspx
More technical stuff at
http://blogs.msdn.com/lcris/archive/category/10357.aspx
John
"TBoon" wrote:
> Can MS SQL 2005 encryp data?
> How to do that?