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 閱讀(390) 評論(0)  編輯  收藏 所屬分類: DBMS

          主站蜘蛛池模板: 建德市| 泸水县| 沙洋县| 富宁县| 师宗县| 饶河县| 彭阳县| 泗洪县| 大理市| 英吉沙县| 宾川县| 禄劝| 平潭县| 惠东县| 都江堰市| 英吉沙县| 玛沁县| 聊城市| 额济纳旗| 吉水县| 繁昌县| 逊克县| 内黄县| 石楼县| 肃南| 祁阳县| 安福县| 疏勒县| 扶绥县| 原平市| 黄平县| 肇源县| 都匀市| 马边| 商城县| 壤塘县| 红桥区| 青浦区| 仁怀市| 太白县| 九龙城区|