• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 728
  • Last Modified:

Null password value in syslogins for master DB.


I'm in an audit and I was asked by my syslogins are showing null password values for the master DB.  If I look at the permissions on the master Db I only have 5 accounts, 2 are service, and the rest built in.  Any ideas why these are showing up?  I'm on SQL 2008 R2, though I upgraded this box from SQL 2008.  I have attached a screen shot of the syslogins table as well as the permissions on the master db

2 Solutions
Scott PletcherSenior DBACommented:
syslogins is an ancient view.  I believe it always returns NULL in the "password" column.
Anthony PerkinsCommented:
As Scott has indicated and SQL Server's BOL confirms:
password   nvarchar(128)   Returns NULL.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now