Post reply

Decrypt the data from the database table?

  • December 1, 2011 at 3:43 am

    #251378

    Is there a way we can decrypt the data from a particular table in sql server 2008?

  • December 1, 2011 at 4:38 am

    #1415154

    Decrypt from what encription?

    -- Gianluca Sartori

  • December 1, 2011 at 4:40 am

    #1415157

    Gianluca Sartori (12/1/2011)

    Decrypt from what encription?

    This funda is very new to me.

    Is there a way to find out what encryption is being used?

  • December 1, 2011 at 4:53 am

    #1415167

    is the data in the table encrypted so when you do

    SELECT col FROM table

    Col is returned in an encrypted state?

    If so it looks like the insert done by the application that has encryption built in, so without the applications decryption routines you would be pretty much.

    If its in house written, you could ask your developers which stored procedures / functions are used to decrypt, then you will need to modify your queries.

  • December 1, 2011 at 5:02 am

    #1415170

    If you're using Transparent Data Encryption, and the key is properly installed on the server, you should just be able to query the data. If not, I think this is probably some kind of third party encryption through an app.

    ----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software

Viewing 5 posts - 1 through 4 (of 4 total)

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