I create a table in sql server 2005 database table_1 with sql login "abc" and the table name appears as abc.Table_1, while if I create table on other 2005 server it appears as dbo.Table_1.
Is there any specific reason for this different behaviour.
sql logins at both the server has dbowner right.
On the first server the default schema for your user 'abc' is 'abc'.
On the second server the default schema for your user is 'dbo', (this is always the case when the user is the database owner).
answered Apr 30 '10 at 12:34 PM
Kev Riley ♦♦