Post reply

Schema_id and Principal_id values sync

  • November 4, 2008 at 1:47 pm

    #195651

    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

  • November 4, 2008 at 7:09 pm

    #894000

    Lotus (11/4/2008)

    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.

    Under normal conditions. These ID's have no direct relation to each other. Your one case of synchronization is merely coincidental. The first time that you explicitly create a new Schema, the succeeding users/schemas will go out of synch again.

    Is there a way to sync these values.

    No. There is no supported way to do this.

    [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
    Proactive Performance Solutions, Inc.     [/font]    [font="Verdana"] "Performance is our middle name."[/font]

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply