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

Posted on 2008-11-19
Last Modified: 2012-05-05
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.
Question by:lakram5455
    LVL 42

    Expert Comment

    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

    Author Comment

    Yes, I am expecting how to encrypt table's column which is used for Full-Text Search.
    LVL 20

    Expert Comment

    by:Marten Rune
    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.


    Accepted Solution

    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?



    Featured Post

    Threat Intelligence Starter Resources

    Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

    Join & Write a Comment

    INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
    In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
    Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
    In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

    730 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now