No. Passwords are encrypted and kept in table master..syslogins table. You can reset a login password with command:
sp_password <sa_password>,<login_password>,<login_name>
But you will not be able to tell the password from syslogins table. Otherwise there will not be any security left.
Hope thias helps