User deletion problem in sql database- SQL Troubleshooting

If you want to delete any user from database security but you are not able to delete that user due to schema then you can change schema authorization to dbo.

To do that you can try following command in sql query analyzer.

use databasename

ALTER AUTHORIZATION ON SCHEMA::YourSchemaName TO dbo;

I hope this post will help you.

Comments