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 field
select 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