1ALTER PROCEDURE dbo.aspnet_Membership_UnlockUser --解除锁定
2 @ApplicationName NVARCHAR(256),
3 @UserName NVARCHAR(256)
4AS
5BEGIN
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
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
27 RETURN 0
28END
2 @ApplicationName NVARCHAR(256),
3 @UserName NVARCHAR(256)
4AS
5BEGIN
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
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
27 RETURN 0
28END