How to Encrypt a SQL Server 2000 Database

From: Kaustav (Kaustav_at_discussions.microsoft.com)
Date: 07/22/04 

Date: Wed, 21 Jul 2004 23:26:01 -0700

Hello,

I am looking for some hint and help on how to go about encrypting a SQL Server 2000 Database. So far I have looked into the possibility of encrypting data in tables using my custom functions, however this process seems pretty slow and resource intensive. Ideally I would want a solution where in the whole DB can be encrypted so that I don't have to make any changes to my stored procedures, functions etc.

In case someone manages to login to EM or Query Analyzer, would he be able to access data or modify stored procedures in such a scenario. Also would he be able to restore the DB from a backup copy and misuse it ?

Also what are the pros and cons of using EFS on Win 2k.

TIA.