Encryption

Hi Guys,
We're currently running SQL Server 2000. We have just been instructed to
ensure that our data is encrypted whenever possible and I was wondering if
any of you could give me some advice about my various options.
I know SQL Server 2005 supports encryption, however, we have a huge amount
of legacy (hard coded classic ASP sql statements) that as far as I can see,
would all need to be updated in order to utilize the native encryption. Is
this the case? Is there a way to encrypt/decrypt a table when it is stored
on the file system as opposed to particular values within it?
We have also looked at the possibility of using EFS for the data storage
folders - has anyone used this before? Is it possible? Any advice on the
implications of this?
The best case scinario would obviously be to have a solution that does not
require us to make any changes to our existing code, but to ensure that the
data is held securely in the event of theft etc.
Any ideas would be really appreciated.
Kind Regards,
ChrisFor column-level encryption, there are lots of 3rd party options available.
Here's one with the perfect price:
http://www.sqlservercentral.com/col...oolkitpart1.asp
I understand others here have used EFS and other tools for file-level
encryption (haven't done so myself), but this might be a good starting
point: http://msdn2.microsoft.com/en-us/library/aa302434.aspx
"Chris Evans" <ChrisEvans@.discussions.microsoft.com> wrote in message
news:F1C1958E-7086-49E1-BCD0-952743FA0F0C@.microsoft.com...
> Hi Guys,
> We're currently running SQL Server 2000. We have just been instructed to
> ensure that our data is encrypted whenever possible and I was wondering if
> any of you could give me some advice about my various options.
> I know SQL Server 2005 supports encryption, however, we have a huge amount
> of legacy (hard coded classic ASP sql statements) that as far as I can
> see,
> would all need to be updated in order to utilize the native encryption.
> Is
> this the case? Is there a way to encrypt/decrypt a table when it is
> stored
> on the file system as opposed to particular values within it?
> We have also looked at the possibility of using EFS for the data storage
> folders - has anyone used this before? Is it possible? Any advice on the
> implications of this?
> The best case scinario would obviously be to have a solution that does not
> require us to make any changes to our existing code, but to ensure that
> the
> data is held securely in the event of theft etc.
> Any ideas would be really appreciated.
> Kind Regards,
>
> Chris