Q

Image encryption in SQL Server 2005

by
Adam Machanic

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 first published in August 2005

Dig Deeper

PRO+

Content

Find more PRO+ content and other member only offers, here.

Related Q&A; from Adam Machanic

SQL vs. T-SQL

SQL Server 2005 and T-SQL do have differences. The advantages and disadvantages would depend user environment as described by SQL Server 2005 expert...continue reading

Determining number of servers needed for large member site

Database servers needed for a site with thousands of users can vary depending on a number of factors, including your necessary level of load ...continue reading

Database Snapshots: Creating read-only copies of a database

Database Snapshots feature in SQL Server 2005 Enterprise Edition creates read-only files. For these separate databases, our site expert Adam Machanic...continue reading

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.

Meet all of our SQL Server experts

View all SQL Server questions and answers

0 comments

Oldest 

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:

-ADS BY GOOGLE

SearchBusinessAnalytics

SearchDataCenter

SearchDataManagement

SearchAWS

SearchOracle

SearchContentManagement

SearchWindowsServer

Close