January 18, 2008 at 11:35 am
having upgraded a database to SQL 2005 from SQL 2000, a schema has been created for each windows group and user created database role in the database.
all objects in the database are owned by dbo, so my feeling is I can drop these schema to tidy things up, am I correct in this view?
---------------------------------------------------------------------
January 21, 2008 at 9:20 am
well, looks like I flummoxed the SQL world again 🙂
so I did some digging and testing:
default database roles (db_accessadmin etc) are created with a schema, and although a new role create does not explicitly create a schema to go with it I can see the logic in a schema associated to a role, so I will leave these.
windows groups - a schema is not explicitly created whn a windows group is added as a user to a database so I will drop these schemas unless the windows groups owns objects within the database, and is obviously fulfilling the role os a database 'role', if you see what I mean..........
---------------------------------------------------------------------
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply