1
ALTER PROCEDURE dbo.aspnet_Membership_UnlockUser --解除锁定
2
@ApplicationName NVARCHAR(256),
3
@UserName NVARCHAR(256)
4
AS
5
BEGIN
6
DECLARE @UserId UNIQUEIDENTIFIER
7
SELECT @UserId = NULL
8
SELECT @UserId = u.UserId
9
FROM dbo.aspnet_Users u, dbo.aspnet_Applications a, dbo.aspnet_Membership m
10
WHERE LoweredUserName = LOWER(@UserName) AND
11
u.ApplicationId = a.ApplicationId AND
12
LOWER(@ApplicationName) = a.LoweredApplicationName AND
13
u.UserId = m.UserId
14
/*查询此用户名的用户ID*/
15
IF ( @UserId IS NULL ) --如果不存在,返回1
16
RETURN 1
17![](/Images/OutliningIndicators/None.gif)
18
UPDATE dbo.aspnet_Membership --存在则更新锁定状态为初始状态(发现这是个要耐心的工作)
19
SET IsLockedOut = 0,
20
FailedPasswordAttemptCount = 0,
21
FailedPasswordAttemptWindowStart = CONVERT( DATETIME, '17540101', 112 ),
22
FailedPasswordAnswerAttemptCount = 0,
23
FailedPasswordAnswerAttemptWindowStart = CONVERT( DATETIME, '17540101', 112 ),
24
LastLockoutDate = CONVERT( DATETIME, '17540101', 112 )
25
WHERE @UserId = UserId
26![](/Images/OutliningIndicators/None.gif)
27
RETURN 0
28
END
![](/Images/OutliningIndicators/None.gif)
2
![](/Images/OutliningIndicators/None.gif)
3
![](/Images/OutliningIndicators/None.gif)
4
![](/Images/OutliningIndicators/None.gif)
5
![](/Images/OutliningIndicators/None.gif)
6
![](/Images/OutliningIndicators/None.gif)
7
![](/Images/OutliningIndicators/None.gif)
8
![](/Images/OutliningIndicators/None.gif)
9
![](/Images/OutliningIndicators/None.gif)
10
![](/Images/OutliningIndicators/None.gif)
11
![](/Images/OutliningIndicators/None.gif)
12
![](/Images/OutliningIndicators/None.gif)
13
![](/Images/OutliningIndicators/None.gif)
14
![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
15
![](/Images/OutliningIndicators/None.gif)
16
![](/Images/OutliningIndicators/None.gif)
17
![](/Images/OutliningIndicators/None.gif)
18
![](/Images/OutliningIndicators/None.gif)
19
![](/Images/OutliningIndicators/None.gif)
20
![](/Images/OutliningIndicators/None.gif)
21
![](/Images/OutliningIndicators/None.gif)
22
![](/Images/OutliningIndicators/None.gif)
23
![](/Images/OutliningIndicators/None.gif)
24
![](/Images/OutliningIndicators/None.gif)
25
![](/Images/OutliningIndicators/None.gif)
26
![](/Images/OutliningIndicators/None.gif)
27
![](/Images/OutliningIndicators/None.gif)
28
![](/Images/OutliningIndicators/None.gif)