How to Encrypt FullText Search Column Value using MS SQL Server 2005?

In one of my project, I am using SQL Server Full Text Search (for ZIP file) features. Which is working fine. Now I want to Encrypt those column value using MS SQL Server 2005.
Who is Participating?
lakram5455Connect With a Mentor Author Commented:
My question is simple. In one of my table, I configured full text  search as shown below. Currently data's in the BODY_CONTENT column are not encrypted and its get stored as  varbinary(MAX).
For security reason, I want to encrypt the data's in the BODY_CONTENT, which is already configured for full text search.

Here I want to know is there any way to encrypt those data's in full text search enabled column so that data's will be more secure and full text search also works. If so how to do?


Eugene ZCommented:
please clarify what you wish to encrypt: table's column used for FTS?
Laurentiu Cristofor's blog
Current topics: Security, SQL Server Simple demo for how to encrypt and decrypt a table column in SQL Server 2005 
lakram5455Author Commented:
Yes, I am expecting how to encrypt table's column which is used for Full-Text Search.
Marten RuneSQL Expert/Infrastructure ArchitectCommented:
If you encrypt a full text column, it's not searchable, you can't index it i e not usefull as full text anymore. Can I ask what you are trying to accomplish. Perhaps you should look at EFS encrypting the folders containing the databases and full text.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.