cuiyi's blog(崔毅 crazycy)

          記錄點滴 鑒往事之得失 以資于發(fā)展
          數(shù)據(jù)加載中……

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

          主站蜘蛛池模板: 邹城市| 东源县| 孟津县| 交口县| 七台河市| 阳西县| 搜索| 邵阳市| 桑日县| 台北市| 绥化市| 平阳县| 益阳市| 宁明县| 阿瓦提县| 扎兰屯市| 稻城县| 余庆县| 蕉岭县| 昆山市| 额敏县| 巴塘县| 逊克县| 合阳县| 大悟县| 忻州市| 开远市| 镇江市| 英超| 济阳县| 青河县| 敦化市| 巴中市| 临沧市| 喀喇| 齐齐哈尔市| 仲巴县| 城步| 嘉义县| 星座| 景泰县|