In a DB called "master", you can view them with
SELECT * FROM master.sys.syslogins
However, passwords are encrypted.
According to Richard’s remark: note that syslogins is no longer a physical table (in SQL Server 2005 and 2008), but only to represent backward compatibility.
source
share