Steps to follow the lock/unlock sybase login
sp_locklogin used to lock/unlock an Adaptive Server account or displays a list of all locked accounts
login isql with system administrator
>sp_locklogin <username>,"lock"
>go
sp_locklogin stored procedure is used to check the locked accounts
>sp_locklogin
>go
to unlock the login
use the below command
>sp_locklogin
<login_name>,"unlock"
>go
