cuiyi's blog(崔毅 crazycy)

          記錄點滴 鑒往事之得失 以資于發展
          數據加載中……

          The database principal owns a schema in the database, and cannot be dropped

          Use UI to configure database, also checked some items in schema;
          while delete this user, an error encounter like this: The database principal owns a schema in the database, and cannot be dropped. (Microsoft SQL Server, Error: 15138)
           
          but use the below script, I successfully removed;
          SELECT s.name
          FROM sys.schemas s
          WHERE s.principal_id = USER_ID('YourUserID');

          find all the schemas to be removed
          ALTER AUTHORIZATION ON SCHEMA::YourSchemaName TO dbo;

          posted on 2013-07-11 17:34 crazycy 閱讀(384) 評論(0)  編輯  收藏 所屬分類: DBMS

          主站蜘蛛池模板: 长岭县| 乌鲁木齐县| 敦煌市| 龙江县| 荆门市| 巴林右旗| 新余市| 凤庆县| 望谟县| 邢台市| 闻喜县| 平罗县| 望都县| 财经| 吐鲁番市| 同仁县| 九龙坡区| 昌乐县| 象山县| 阳高县| 江口县| 江门市| 偏关县| 盖州市| 米脂县| 上栗县| 延边| 武城县| 阿荣旗| 吉木萨尔县| 清丰县| 红桥区| 民权县| 曲靖市| 大荔县| 察雅县| 岗巴县| 兴海县| 福贡县| 海丰县| 邛崃市|