Hi There
In SQL Server logins are encyrpted by default. However you can create a login without encrypting the password, but it is not recommended.
--------------------------------------------------------
Example: Creating a login for Mary with password
- rose without an encrypted password
------------------------------------------------------
EXEC sp_addlogin 'Mary', 'rose',
@encryptopt = 'skip_encryption'
--------------------------------------------------------
To read the password in Master..syslogins:
--------------------------------------------------------
SELECT password FROM syslogins where name = 'Mary'
--------------------------------------------------------
To create a password with encryption (default)
--------------------------------------------------------
EXEC sp_addlogin 'Mary', 'rose
--------------------------------------------------------
Read encrypted password for Mary
--------------------------------------------------------
SELECT CONVERT(VARBINARY(32), password)
FROM syslogins
WHERE name = 'Mary'
Hope this helps
Good Luck
Bernadette