Skip to Content
Author's profile photo Javier Ernesto Barthe

Locking Inactive Logins – ASE 15.7 SP 134


I want to lock logins inactive for more than 90 days so I´m executing:

sp_locklogin NULL, ‘lock’, NULL, 90

But after executing it I´m getting the following output:

Warning: One or more accounts specified are active.

Account locked.

(return status = 0)

So I decided to open de sp_locklogin code and discover that the reason is in line 919:


When @except is null and @loginame is null (1st and 3rd parameters of sp_locklogin) there is not a check before of what logins are going to be blocked in order to join with only these ones and not with all syslogins.

So don´t care about the message its just a luck of funcionality inside sp_locklogin and results are correct.



Assigned Tags

      Be the first to leave a comment
      You must be Logged on to comment or reply to a post.