Dears,I have created a asp.net user through asp.net membership form. Here my question that after I crated this user then password stored as in encrypted text. I need to write a sql query to decryption the password to be a readable password.Below is my code but it give null value for the decrypted password fieldselect u.UserName as UserName, u.UserId UsID, m.Email as Email, m.Password as pwd,convert(varchar(10), decryptbykey(m.Password, 1, convert(varchar(100), m.UserId))) as pwd from aspnet_Membership m, aspnet_Users u where u.UserId = m.UserId
RegardsShaji
Decrypt encrypted password
Posted - 2012-09-26 : 02:33:34
