Encrypt data in SQL Server 2000

  • I am trying to decide which is a better method to use to encrypt data in SQL Server 2000. There are several 3rd party tools that utilize either extended procedures to provide encryption or encrypt the data with a control instantiated through use of sp_OACreate. I am a little worried about both of these techniques b/c of the chance that under load they could fail and require the rebooting of the database server to fix. The other technique I was thinking about using is to do the encryption at the application level instead of the database level. Has anyone had any experience with any off these methodologies in a high volume OLTP shop? Any advice on which method provides the best results in terms of stability, security and performance would be appreciated.

    Thanks

    Chari.R.V.

  • Please do not cross-post, we monitor all boards.

    Finish the thread here : http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=9&messageid=194832

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply