Knowledge Base - Technical Articles
FAQ: Can I use Microsoft SQL Server computed column with ArcSDE?
| Article ID: | 30565 |
|---|---|
| Software: | ArcSDE 8.3, 9.0, 9.1 |
| Platforms: | Windows NT 4.0, 2000, 2003Server |
Question
Can I use Microsoft SQL Server computed column with ArcSDE?
Answer
No, this is not possible.
A computed column does not get stored in physical storage. Having created a column that concatenates two fields, ArcSDE allows tasks as:
1. Use a feature class with this type of column.
2. Edit the column in an ArcMap editing session.
3. Make and save changes.
However, when compressing the database, the compress operation fails and the following error message appears in the command prompt:
"ArcSDE 9.1 SQL Server Build 2178 Thu Oct 20 11:16:11 PDT 2005
Version Administration Utility
-----------------------------------------------------
Compress state tree: Are you sure? (Y/N): Y
Error: Underlying DBMS error (-51).
Error: Unable to compress state tree.
Microsoft OLE DB Provider for SQL Server: Column 'TEST2' cannot be modified because it is a computed column."
This is because ArcSDE tries to update that column and the SQL statement fails, which causes a -51 error for ArcSDE. The edits in the A & D tables for that feature class cannot be moved into the business table.
A computed column does not get stored in physical storage. Having created a column that concatenates two fields, ArcSDE allows tasks as:
1. Use a feature class with this type of column.
2. Edit the column in an ArcMap editing session.
3. Make and save changes.
However, when compressing the database, the compress operation fails and the following error message appears in the command prompt:
"ArcSDE 9.1 SQL Server Build 2178 Thu Oct 20 11:16:11 PDT 2005
Version Administration Utility
-----------------------------------------------------
Compress state tree: Are you sure? (Y/N): Y
Error: Underlying DBMS error (-51).
Error: Unable to compress state tree.
Microsoft OLE DB Provider for SQL Server: Column 'TEST2' cannot be modified because it is a computed column."
This is because ArcSDE tries to update that column and the SQL statement fails, which causes a -51 error for ArcSDE. The edits in the A & D tables for that feature class cannot be moved into the business table.
Created: 3/28/2006
Last Modified: 12/18/2009
