When you use the SQLServer2000 to change the object (Object) (such as Table, SP, View), you need to pay attention to a point:
If the Owner before the object changes to DBO, use: Exec SP_CHANGEOBJECTOWNER object name, the new owner name can be successful. If you need to change the owner of the object, use the following syntax:
EXEC SP_CHANGEOBJECTOWNER "[Owner]. [Object Name]", new owner. Note that double quotes are not eliminating, otherwise ObjectName Does Not Exist.
