Sql Server Membership User: Unlock and Change Password

asp-membership-user-unlock-and-change-password-query.sql

--Unlock User
DECLARE @return_value int

EXEC @return_value = aspnet_Membership_UnlockUser
  @ApplicationName = '/',
  @UserName = 'user_name'
  SELECT 'Return Value' = @return_value
GO

--Get required details using another known User
SELECT 
    au.username, aa.ApplicationName, password, passwordformat, passwordsalt
FROM 
    aspnet_membership am
INNER JOIN 
    aspnet_users au ON (au.userid = am.userid)
INNER JOIN 
    aspnet_applications aa ON (au.applicationId = aa.applicationid)
WHERE
    au.UserName = 'other_user_name';
    
-- Change Password
DECLARE @changeDate DATETIME
SET @changeDate = GETDATE()

EXEC aspnet_Membership_setPassword 
    'applicationName',
    'user_name',
    'other_user_password',
    'other_user_password_salt',
    @changeDate,
    other_user_passwordformat