We have SQL Server 2000 and the database named CP with the User CPAdmin. CPAdmin this user owns all the objects in the database. Yesterday suddenly, we are unable to access the objects directly.
ie, Select * From tbl1 is not working even though we logged in as the user CPAdmin. If we give like Select * From CPAdmin.tbl1 it's working.
May i know if any of u come across the same porblem and how did u solve it?