|
KB Article - 239133
SYMPTOMS
When you run SQL Server Enterprise Manager wizards against objects owned by anyone other than yourself or the database owner (DBO), you may receive errors and the wizard may not complete successfully.
Error 21776: [SQL-DMO] The name 'XXXX' was not found in the Users collection.
CAUSE
The Enterprise Manager does not allow you to specify an owner. So, if you are not logged on as the object owner and the object is not owned by the DBO, the wizards will not find the object.
WORKAROUND
Use sp_changeobjectowner to change the owner of the table to the DBO, and then run the wizard again.
Also see articles:
KB 218172
|