Search Engine: Elastic

Article ID: 129738, created on Oct 29, 2016, last review on Oct 29, 2016

  • Applies to:
  • Operations Automation


Task for dropping of database user fails with the error:

Cannot change owner of object 'u123456_username.aspnet_Setup_RestorePermissions' or one of its child objects because the new owner 'dbo' already has an object with the same name."


Error occurred because indeed dbo sys user already has mentioned sys objects.


Existence of such sys objects can be checked on DB host that is mentioned in failed task. Query should be like:

select * from  dbo.sysobjects where name='aspnet_Setup_RestorePermissions';

Confirm that there are such records, delete them, after that the task can be processed.

5356b422f65bdad1c3e9edca5d74a1ae caea8340e2d186a540518d08602aa065 e12cea1d47a3125d335d68e6d4e15e07

Email subscription for changes to this article
Save as PDF