Active an account in Fee Database

Created by Hamta Fakhravar, Modified on Mon, 30 Oct, 2023 at 5:04 PM by Hamta Fakhravar

UPDATE t
SET IsLockedOut = 0,
FailedPasswordAttemptCount = 0,
FailedPasswordAttemptWindowStart = CONVERT( datetime, '17540101', 112 ),
FailedPasswordAnswerAttemptCount = 0,
FailedPasswordAnswerAttemptWindowStart = CONVERT( datetime, '17540101', 112 ),
LastLockoutDate = CONVERT( datetime, '17540101', 112 )
----select *
FROM DTIntranet.dbo.aspnet_Membership t
where LoweredEmail='anardulli@dt.com'

--*******************************************************************

DECLARE @NumTablesDeletedFrom int

EXEC DTIntranet.dbo.aspnet_Users_DeleteUser '/','nardullia',15,@NumTablesDeletedFrom

SELECT @NumTablesDeletedFrom