February 28, 2003 at 11:15 am
Dear all
How can i decrypt the data stored in a table.??
Here my customer is having a table of username and password and he forgot his pasword. but in sql server table it is in an encrypted format (not readable format)How can i read it
Help me
February 28, 2003 at 2:35 pm
When you say table, do you mean the system table like sysxlogins or do you mean a user table. If you mean a user table, you'll need to know the encryption algorithm they used.
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
K. Brian Kelley
@kbriankelley
February 28, 2003 at 11:38 pm
I mean User Table
I don't know which algorithm they were used
It is in an unreadable format.Can you say how can i store(what data type) these kind of data in a user table
I mean how to encrypt the data in table either through a sql query of through an application
Regards
subhashkvsql
March 1, 2003 at 6:09 pm
They could do either thru an SP or UDF (if 2000) or within the application submitting to send the data in. However a good programmer will do one way encryption instead of two making it almost impossible (some method more than others). You will have to know how it was encrypted to figure out how to decrypt.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply