I was going through the sys.server_principals and sys.sql_logins views in BOL and I noticed that for sys.sql_logins BOL says that some of the columns are inherited from sys.server_principals.
However, I looked at the view script for sys.sql_logins (sp_helptext [sys.sql_logins])and no where do I see sys.server_principals being used or referred. So, where is the question of inheritance coming in here? Looks like both the views derive columns
from sys.sysxlgns,sys.syspalnames and sys.syssingleobjrefs
View Complete Post