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.
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
Post a Comment
Please avoid link comments