Latest Contributions by VinceAngelo

I meant support for SQL-Server's spatial types -- GEOMETRY and GEOGRAPHY columns. The combination itself is completely unsupported by Esri (9.1 is in "retired" status). - V ... View more

Robert brings up a great point.  If you want your geodatabase to be portable, you should also strive to check your naming against *all* RDBMS keywords (most of which are SQL reserved words ["SELECT", "FROM",...], and many of which have overlap ["TABLESPACE"]). - V ... View more

SQL-Server 2008 support was not introduced until ArcSDE 9.3.  There is little chance that this combination will work (see Vince's First Law of Compatibility), and no chance at all for spatial type support. - V ... View more

This is the same as any SQL restriction.  First letter must be alpha.  Remaining letters may be alpha-numeric or underscore.  No spaces. No hyphens (which would be interpreted as "minus"). Keep in mind that these column names will be substituted for by row contents when the SQL algebra and calculus is applied, so math symbols and punctuation would make parsing the SQL expressions difficult, at best. While name length is limited to 64 characters, you should really expend effort in trying to keep column names inside 20 characters (ideally, 30 max), just to make your SQL readable.  The only reason you should keep the name under 11 characters is if you intend to make shapefiles out them on a regular basis, but making sure the names differ in the first 10 characters will make your life easier. There is very little similarity between a column heading in a spreadsheet and a column name in a database (the same level of similarity between spreadsheets and databases, come to think of it). - V ... View more

Editing the SDE_* and GDB_* tables is very much not recommended (and almost never necessary). The supported mechanism for acknowledging new columns is to run 'sdetable -o describe' as the table owner. - V ... View more

There won't be a solution for this until 10.1 is released. - V ... View more

While it might seem like ArcSDE was okay with it, NUMBER is not a valid rowid column type, since it maps to SE_FLOAT64_TYPE. You can't remove entries in the column registry without risking your ArcSDE instance, but you may be able to update the row to contain the modified type information (but this should be done under the guidance of Tech Support). - V ... View more

The safest way to add columns to a versioned table is to reconcile and post all your updates, unversion, make the table changes, and re-register the table as versioned.  You can't just alter the table, since the ADDs table will not have the parallel columns added. - V ... View more

Direct Connect doesn't requrire a hostname, so changing the port often isn't enough. What version of ArcSDE are you using? Is the application server service running? What exact error messages are you receiving (as text, preferrably)? - V ... View more

It helps to keep the terminology straight: + ArcSDE operates with 'tables' and 'layers' + ArcGIS operates with 'feature classes' Only ArcGIS can register a new feature class in an ArcSDE geodatabase for editing with ArcGIS (and only with the ArcEditor or ArcInfo license levels). If you are using ArcGIS 10, you don't need to use ArcSDE to access tables with GEOMETRY/ GEOGRAPHY columns -- instead you can use query layers. - V ... View more

There are no ArcSDE command-line utilities which change anything managed by ArcObjects (geodatabases are implemented on top of ArcSDE functionality). - V ... View more

UPDATE and INSERT events don't occur when a versioned table is edited (both are modeled as INSERTs to the Adds tables; UPDATEs also INSERT to the Deletes table).  When reconciied, compressed, and posted, the changes are implemented as an INSERT (or DELETE then INSERT in the case of an UPDATE), but this usually occurs *much* later than the original edit. You might experiment with triggers on the Adds table, but that is unsupported (and outside the scope of this thread). - V ... View more

There was a recent thread on counting feature classes -- the Python script could be trivially modified to display the objects counted. - V ... View more

Desktop licensing determines whether you have privilege to modify tables. I had to enable JavaScript to make Firefox work. - V ... View more

Nothing wrong with those links from here (in IE8 or Firefox 6). Are you using an ArcView license? - V ... View more