Sqlserver because the selected user has an object, the solution for this user cannot be removed. sqlserver Solution

Sqlserver because the selected user has an object, the solution for this user cannot be removed. sqlserver Solution

Symptom:
Restore the database that was backed up to the current SQL database. Now, you need to delete the user in the database, but the result shows that the user cannot be removed because the selected user has an object.
Solution:

1. Open the Enterprise Manager, expand the server, right-click the local server,Attribute:

Open the SQL Server properties (configuration) window
2. SelectGeneralWindow
Select the server settings window and setAllows direct modification of System DirectoriesSelect, OK.
4. Expand the database, view the database system table sysusers, right-click --Open Table--Returns all rows.:

5. Select the user to be deleted from the database, find the relevant row, and right-clickDelete:


SelectYes,
LastThen return to step 2Allows you to directly modify the system directory.Remove