Skip to main content

Posts

Showing posts with the label wrong schema

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.