Ways to modify the Sybase database sa password

Problem Description:

You cannot start Sybase Center on Unix and some systems, so how do you modify the sa password in this case, and use this method to place the sa password blank if we do not need a password

Solution:

$isql -Usa -P1222 -SSYBASE
1>sp_configure "upgrade version"
2>go

#记录打印的版本号, my system version is 11920 (Sybase 11.9.2).

1>sp_configure "upgrade version",492
2>go

#更改版本号为492

1>sp_password '123456',NULL,sa
2>go

#修改密码将123456密码置为空

1>sp_configure "upgrade version",11920
2>go

#更改版本号为原来的版本号