I am trying to change the Schema name of an existing DB using the below Alter Code... but then I get an error saying
Msg 15151, Level 16, State 1, Line 1
Cannot find the object 'SALESPEOPLE', because it does not exist or you do not have permission.
The user is the Owner of the Database and I can clearly see the Object Named SALESPEOPLE in the tables list and the User Name with all the rights....
help me out... I might be doing it wrong so I would appreciate a Step by Step Process of creating a schema and then changing the Default Schema.... also how to check all the required user permissions..
ALTER SCHEMA DBO