I created a login under specific database i.e windows authentication and provided the admin rights as db_owner on the server.when i tried to delete the user, it says cannot delete the login, in brief the error as follows:
The database principal owns a schema and cannot be dropped.15138 sql server
can anybody help me on this, why i am not able to delete the user and...
1. how many schemas are available in sql server 2008/2005/2000.
2. Is db_datareader,db_datawriter,db_owner,db_accessadmin all these belong to schema's
thanks in advance