topic SQL server - Cannot alter table in foreign schema in Data Management Questions https://community.esri.com/t5/data-management-questions/sql-server-cannot-alter-table-in-foreign-schema/m-p/525809#M29838 <HTML><HEAD></HEAD><BODY><SPAN>Hello everobody,</SPAN><BR /><SPAN>there is a problem to modify feature class schema (i.e. add attribute) when this "table" is created in different schema. Even if alter table is allowed in SQL server and works fine directly in Management Studio, ArcCatalog probably controls the role of connected user. Only DB_OWNERs and SYSADMINs do this.</SPAN><BR /><BR /><SPAN>Does anybody know any workarround?</SPAN><BR /><SPAN>Thanks</SPAN><BR /><BR /><SPAN>Kuba</SPAN></BODY></HTML> Fri, 27 May 2011 06:34:44 GMT JakubOrálek 2011-05-27T06:34:44Z SQL server - Cannot alter table in foreign schema https://community.esri.com/t5/data-management-questions/sql-server-cannot-alter-table-in-foreign-schema/m-p/525809#M29838 <HTML><HEAD></HEAD><BODY><SPAN>Hello everobody,</SPAN><BR /><SPAN>there is a problem to modify feature class schema (i.e. add attribute) when this "table" is created in different schema. Even if alter table is allowed in SQL server and works fine directly in Management Studio, ArcCatalog probably controls the role of connected user. Only DB_OWNERs and SYSADMINs do this.</SPAN><BR /><BR /><SPAN>Does anybody know any workarround?</SPAN><BR /><SPAN>Thanks</SPAN><BR /><BR /><SPAN>Kuba</SPAN></BODY></HTML> Fri, 27 May 2011 06:34:44 GMT https://community.esri.com/t5/data-management-questions/sql-server-cannot-alter-table-in-foreign-schema/m-p/525809#M29838 JakubOrálek 2011-05-27T06:34:44Z