Incorrect Default Schema in Database
The problem with the incorrect schema most likely occurs because your user account in the database has had the default schema set to your account instead of dbo. You can check that by bringing up Properties on the user in SSMS. The default schema should be null, which is then interpreted as dbo. The user interface will not allow you to change the default schema to null and neither will the ALTER USER command. The only way we’ve found to make the default user null is to delete and recreate the user, leaving the Default Schema blank.
Revised: 2012-06-14
Copied!