|
|
Posted by Mike C# on 07/24/06 03:13
You don't specify if you're using 4.21a, 6.0, 6.5, 7.0, SQL 2005 or SQL
2000. If SQL 2005, look into the built-in Transact-SQL encryption
functionality. If SQL 2000, look into this:
http://www.sqlservercentral.com/columnists/mcoles/sql2000dbatoolkitpart1.asp.
If SQL 7.0 or lower, upgrade ASAP.
"Sav" <sav.smb@gmail.com> wrote in message
news:1153412674.112270.128440@i3g2000cwc.googlegroups.com..
> Hi,
>
> I'm developing a software that makes a lot of access to a MS SQL
> Server. All information in the data base is decrypted and encrypt upon
> each read and write access -- this is causing a big overload of CPU in
> my system. I'd like to implement something to make it faster so I
> wondered if there is any MS SQL Server API that would make the
> cryptography transparent for the application. Another solution would be
> setting up an encrypted file system so I could unmount
> the device when the application finishes. The last one is not optimal
> though, since the encrypted device would have read access while
> mounted.
>
> So, I'd like to get some suggestions about tools, api's and probably
> other better solutions. Any information would be of great help.
>
> The software runs on Windows 2k, Windows XP, Windows 2k3, Windows NT
> and probably would have to be ported to Vista.
>
> thanks a lot in advance for any help,
>
> s
>
Navigation:
[Reply to this message]
|