How to get a default schema assigned to windows group in sql server 2005

  • How to get a default schema assigned to windows group in sql server 2005?

    we need a windows group to have a default schema of 'dbo' so that all tables created by members of the group

  • This is very clearly spelled out in Books Online (BOL) under the topic default schemas. You cannot set a default schema for a windows group.

    From Books Online:

    If DEFAULT_SCHEMA is left undefined, the user will have dbo as its default schema. DEFAULT_SCHEMA can be set to a schema that does not currently occur in the database. Therefore, you can assign a DEFAULT_SCHEMA to a user before that schema is created. DEFAULT_SCHEMA cannot be specified for a user who is mapped to a Windows group, a certificate, or an asymmetric key.

    Jeffrey Williams
    “We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

    ― Charles R. Swindoll

    How to post questions to get better answers faster
    Managing Transaction Logs

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

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