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
, 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
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.
Dig deeper on Microsoft SQL Server 2005
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
Multiple readers can sometimes read the same row simultaneously causing a false result. SQL Server 2005 expert Adam Machanic suggests modifying the ...continue reading
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.