Ask the Expert

Image encryption in SQL Server 2005

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.

This was first published in August 2005

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: