If you are accessing tables via middle-layer components (and only through middle-layer components) you could encrypt the data in the middle layer using the Windows Crypto API. I have had a lot of success with this approach. Unfortunately, in the case of a bulk update, it adds overhead.
>Is there any encryption package (ex. PGP) available for SQL Server 2000.
>
>I noticed that in the MASTER DB, there is a node for External Stored Procedures that we can linked to DLL. Is it only available in the MASTER DB ? if so any idea why ?
>
>Thanks!
The whole problem with the world is that fools and fanatics are always so certain of themselves, but wiser people so full of doubts. - Bertrand Russell