I would like to have image fields encrypted, but my programmer hasn't been able to do it. I understand SQL Server 2005 has a greater capability in this regard. Is encrypting image fields (some holding large amounts of data) doable?
Requires Free Membership to View
SQL Server 2005 has much, much greater capabilities in that regard, and I believe that your programmer will have an easier time accomplishing your project objectives. I encourage you to check out Laurentiu Cristofor's Web log, which includes extensive coverage and many demos of how to use SQL Server 2005's encryption features.
In the meantime, you may still be able to find a solution for SQL Server 2000. Michael Coles recently posted an article on implementation of the Blowfish algorithm in an extended stored procedure for SQL Server 2000 encryption. The article should help you get going now, instead of waiting for SQL Server 2005.
Do you have comments on this Ask the Expert Q&A? Let us know.
Do you have comments on this Ask the Expert Q&A? Let us know.
This was first published in August 2005
Join the conversationComment
Share
Comments
Results
Contribute to the conversation