December 1, 2011 at 3:43 am
Is there a way we can decrypt the data from a particular table in sql server 2008?
December 1, 2011 at 4:38 am
Decrypt from what encription?
-- Gianluca Sartori
December 1, 2011 at 4:40 am
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
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
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 Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply