I have a sql 2005 db in which schema_id and principal_id values are the same in sys.schemas view is most cases except for few, these values are different. Under what conditions can these be different.
Is there a way to sync these values. I understand the principal_id is coming from sys.database_principals view. Is there a way to sync up such that these 2 values will be the same.
Thanks