Can I use the orders table like the following:

databaseName..orders     ????

if yes then where the SqlServer will search for the object first?

Regards,

Vivek

yes.

prior to sql2005 sqlserver would search for ...

databaseName.YOURLOGINUSER.orders    

then for databaseName.DBO.orders    

with sql2005 it will start searching for ...

databaseName.YOURDEFAULTSCHEMA.orders    

then for databaseName.DBO.orders    

     Jul 13  

Sometimes this is me