MS SQL Server - Data Encryption

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Data Encryption

TBoon

2006-12-05, 12:12 am

Can MS SQL 2005 encryp data?
How to do that?

John Bell

2006-12-05, 5:16 am

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/it.../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?

Sponsored Links