ALTER LOGIN ENABLE

where is the
ALTER LOGIN ENABLE
bit stored? is this something that can be queries to see which logins are enabled and which ones are not?
LVL 5
25112Asked:
Who is Participating?
 
Eugene ZConnect With a Mentor Commented:
this info is stored in the read only system Resource database - mssqlsystemresource
with ability to be viewed via system views from master DB
as per above post
sys.server_principals view
0
 
Steve WalesConnect With a Mentor Senior Database AdministratorCommented:
Have a look at the "is_disabled" column is sys.server_principals

See the Documentation: http://msdn.microsoft.com/en-us/library/ms188786.aspx
0
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.

All Courses

From novice to tech pro — start learning today.