Problem solve Get help with specific problems with your technologies, process and projects.

Image encryption in SQL Server 2005

SQL Server 2005 will have better image encryption capabilities, but expert Adam Mechanic gives you the resources to encrypt images now in SQL Server 2000.

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?
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.
This was last published in August 2005

Dig Deeper on Microsoft SQL Server 2005

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.