Post reply

default schema

  • October 13, 2010 at 2:11 pm

    #229641

    I have created a sql user from which when a table is created it gets "dbo" schema assigned but when i try the same for a windows group it does not, why is it so?

    do i have to set a default schema for win group so that it created table with "dbo"

  • October 15, 2010 at 3:47 am

    #1237377

    Objects created by users belonging to db_owner role gets dbo schema (this was the behavior in SQL Server 2000, if I remember correctly). I think your windows user does not belong to db_owner role.

    Anyway, use following syntax to change the default schema:

    ALTER USER <user> WITH DEFAULT_SCHEMA = <schema>

    Hope this helps you.

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

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