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.toyota i 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?
Hi, First check how many schema is mapped with user mex? If this user is having multiple schema then transfer schema to other user except car. (Note:If you want mex to access only toyota table)
Use (Database_Name) GO SELECT name FROM sys.schemas WHERE principal_id = USER_ID('mex') --Transfer all schema to other user Go ALTER AUTHORIZATION ON SCHEMA::[db_owner] TO [dbo]
Then only you can access table using below query 'select * from toyota'.
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.toyota i 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?
are you sure you've logged in using mex user itself?
------------------------------------------------------------------------------------------------------ SQL Server MVP http://visakhm.blogspot.com/
Selecting tables from a non dbo query schema
Posted - 01/25/2013 : 13:46:34
