Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
johnsql
Posting Yak Master
161 Posts |
 Posted - 2008-03-24 : 13:40:36
|
| Buddies, A table is designed with a value-encrypted column. I'd like to read its values. How can I do so?Thank you in advance. |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-03-24 : 14:20:02
|
Contact the vendor, ask them for which encryption was used and then ask for password.
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
johnsql
Posting Yak Master
161 Posts |
Posted - 2008-03-25 : 09:19:39
|
quote:
Originally posted by Peso
Contact the vendor, ask them for which encryption was used and then ask for password.
E 12°55'05.25"N 56°04'39.16"
Thank Peso,Unfortunately, the table designer has left my company long ago and there is no document of it. Because the table has been rarely used until now, I must work on it with some pre-existing sample data rows. |
|
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2008-03-25 : 09:50:17
|
| You understand that you have asked us "how to open a safe without the key", right?The very reason you encrypt data is so people can't read the data. If there was a simple "turn off encryption" option, that' wouldn't be very secure, would it?You need find out the encryption algorithm and get any keys necessary. Without them, you are pretty much out of luck.- Jeffhttp://weblogs.sqlteam.com/JeffS |
|
|
|
|
|
|
how to read values of an encrypted column