SQL isolated user solution ~

The reference content often becomes inaccessible to tables by account after database backup and system replacement. The following is a general example.

Run the following statement to change the owner of the table in the current database to DBO. Of course, you can change the owner of the table to another one as long as you modify the UID value.

Sp_configure 'Allow updates', '1'
Go
Reconfigure with override
Go
Update sysobjects set UID = 1 where uid <> 1
Go
Sp_configure 'Allow updates', '0'
Go
Reconfigure with override

Then, delete the isolated account in the user option in the database...

Note: The following statements can be used for uid query:

Use master
Select *
From sysusers
Where uid> = '1'