In SQL server 2008 - there are multiple users set up with their own schema under a common database. Currently the users are set up with dbo as their default schema. Since DBA
has not given write access to the users to write to dbo schema, users have to write their t-sql se create table schemaname.tablename instead of create table tablename.
Can you make the user schema as their default schema. If yes then will a sql like create table table1 work (with out prefixing the schemaname). I could have tried but don't have
the access to change the default schema for an user (not a dba)
View Complete Post