Post reply

How Encrypt all Table rows data

  • April 27, 2010 at 9:56 pm

    #220081

    Hi,

    Can anyone help me on

    Encrypt all Table rows data so that select query will give only encrypted data in sql query result area.

    If application wants data it will fatch data by providing decryption password and get data for application.

    Can above thing posible using sqlservre?

  • April 27, 2010 at 10:16 pm

    #1158634

    Yes, but you will have to encrypt based on each column. Also, you won't want every column encrypted, for this will kill any performance because you will be indexing on encrypted data, which is effectively meaningless for trying to do a lookup.

    K. Brian Kelley
    @kbriankelley

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply