sp_ClientUserPasswordHistoryCleanup

Parameters

Parameter	Parameter Type	Mode	Description
@UserID	int	IN

Definition

Copy



            CREATE PROCEDURE [dbo].[sp_ClientUserPasswordHistoryCleanup]
            (
                @UserID        int
            )
            AS
            BEGIN
                set nocount on

                delete from ClientUserPasswordHistory where
                    userid=@UserID and id not in 
                    (select top 4 id from ClientUserPasswordHistory where userid=@UserID order by dateused desc)
            END