Hi,
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.
Thanks.
Javier.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
11 | |
10 | |
7 | |
6 | |
4 | |
4 | |
3 | |
3 | |
3 | |
3 |