Tables created by default in user schema

Question

In Sql Server 2008, when I create a table without schema prefix:

create table mytable ( id int identify )

it usually ends up in the schema dbo, with name dbo.mytable.

However, on one of our servers, the tabel ends up belonging to me:

andomar.mytable

Which configuration difference could explain this?

Answer 1

It depends what your default schema is within that database. Even in SQL Server 2005, if your default schema in that one database is andomar, then any tables created without an explicit schema will end up there.

Check the user properties in that database (not the login properties) and see what the default schema is.