SQL Server 2000 doesn't support encryption natively you have to use third party DLLs as extended stored procedures to handle the encryption and decryption of data. These extended stored procedures should be called from within your regular stored procedures so it doesn't matter what front end language you use.
Another option is to use 3rd party vendor solution. There are a number vendors who support database encryption (data at rest) with both symmetrical and asymmetrical encryption keys. They support full database encryption or column level encryption. These systems are program or language independent. The data are kept encrypted & encryption/decryption occurs when valid users (supported by Policy Enforcement Module) access the data. Of course this solution is a bit expensive. It works on enterprise level so one can use the system for any number of databases.
It works on any database and for any language. I do not want to bias by giving the name of a particular vendor. But a search for database encryption on the Internet will reveal the names of a number of leading vendors.
Last Wiki Answer Submitted: December 8, 2008 6:37 pm by Denny Cherry64,520 pts.