Select to view content in your preferred language

SQL server - Cannot alter table in foreign schema

570
0
05-26-2011 11:34 PM
JakubOrálek
Occasional Contributor
Hello everobody,
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.

Does anybody know any workarround?
Thanks

Kuba
0 Kudos
0 Replies