EFS is a very interesting technology... perfect for mobile users who might accidently get drunk with a laptop holding military software:

http://english.pravda.ru/main/2002/10/22/38519.html

If you've got sensitive data, this is definitely a technology to consider. The public key encryption is RSA and the symmetric is DESX, two established and proven encryption algorithms. The fact that it's seemless to SQL Server (unless we use the wrong account to encrypt) is another big plus.

K. Brian Kelley

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL Server Performance Monitoring

http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1