MSSQL 2005 database schema: what is the different between dbname.dbo and dbname
Posted on 2010-09-08
i have create a database with name "dbname" in MSSQL Server 2005.
as i use hibernate to manipulate the database, i was asked to tell the database schema.
in one computer i must use "dbname" as database schema, in another one i must use "dbname.dbo" as database schema.
i would like to know what is the different between dbname.dbo and dbname. how can i find which database schema is used in MSSQL Server?