Please start any new threads on our new
site at http://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Our new SQL Server Forums are live!
Come on over! We've restricted the ability to create new threads on these forums.
Yak Posting Veteran
Constraint Violating Yak Guru
Very Important crosS Applying yaK Herder
quote:Originally posted by xrumi have some tables in a car schema.i changed my user's default schema to carbut when i try to do the following:select * from toyotai still get the following:Msg 208, Level 16, State 1, Line 2 Invalid object name 'toyota'.i have to specify car before it works like so:select * from car.toyotai already did this:ALTER USER mex WITH NAME = mex;ALTER USER mex WITH DEFAULT_SCHEMA = car;is there something else i'm missing? how can i keep the car schema but still be able to query it with just the table name?