Sybase Admin

To unlock a user (login as sa):

sp_locklogin user_name, "unlock"

To display information about an account, including whether or not it is locked (login as sa):

sp_displaylogin user_name

To view all logins (login as sa):

select * from syslogins

To change the user's password (login as sa):

sp_password sa_password, new_user_password, user_name

To find out what version of Sybase is running:

select @@version