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.

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 Update statement password field

Author  Topic 

cplusplus
Aged Yak Warrior

567 Posts

Posted - 2011-03-23 : 12:32:51
I have a free program the passwords are stored this way:
D82B9EC080F99E03872ED22A27FA93E9

the datatype of that field is varchar(100)

This is a free program lost my password is there way to update via sql server update statement i tried to use MD5 hash, i got a message row updated but it did'nt work.

The front end of teh program login screen has a decyphering code, but don't know what type of encryption this is.

table name tb_users, fieldname: us_password

Thank you very much for the helpful info.
   

- Advertisement -