How to change the owner of the User table of SQL Server 2000 to DBO instead of the user name?

Exec sp_changeobjectowner '[bbsdb]. [dv_style]', [DBO]
Change the owner of objects in the current database
When you back up and restore the database, the owner is often the original user, so that when you use
When the table name is invalid, an error message is displayed. if you add the original user name, an error occurs,
So the best way is to change it to DBO:
How to change the owner of the User table of SQL Server 2000 to DBO instead of the user name.
(The method for modifying the stored procedure is attached and executed in the queryer:
Exec sp_changeobjectowner 'usera. hishop_creatorder', 'dbo'), change the stored procedure of usera to DBO.
You can use sp_changedbowner to change the database owner.
Method 1: Right-click the table and choose design table from the shortcut menu. In the previous small icon, click the last "condition constraint" and click the "table" page to change the owner. (If there is no small icon with constraints, you can right-click to see a "Check constraint" option)
Method 2: Execute the script directly, log on to the database with a system account or a super user, and then execute the following statement:
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
The second method can only be used once. The second method may cause an error.