Latest Contributions by RashanWalker

Currently in an Oracle database you can't change the order of fields in a feature class. The feature class can be re-created with the fields in the correct order.  The "Load Object" command can then be used to populate the feature class. Loading data with the Load Objects command http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#/Loading_data_with_the_Load_Objects_command/003n0000003z000000/ Steps: 1.  Create a new feature class with the column in the correct order 2.  Load the data from the old feature class into the new feature class using the �??Load Objects�?� command 3.  Fields can be matched using the �??Matching Source Field�?� drop down box *** Important Note for �??Versioned Feature Classes�?� *** If you are loading into a versioned ArcSDE feature class with ArcMap, the data loads into the delta tables, not the base tables. After you have finished loading into any feature class or table registered as versioned without the option to move edits to the base table, compress your database to push all the records from the delta tables to the base tables. Having your data in the base tables results in faster queries than if you have large amounts of data in your delta tables.. ... View more

ArcSDE log file tables in a geodatabase in SQL Server http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//002q0000007t000000 SDE_session<SDE_ID> The SDE_session<sde_ID> table is created when you are using session-based log files.  This table is used to track log file records when a connected session creates a selection set that exceeds the application threshold (100 records in ArcMap).  The SDE_session<sde_ID> table is dropped when the session disconnects. Please contact ESRI Support Services to see if this is related to ESRI bug #NIM031995 (fixed in ArcGIS 10 service pack 1). ... View more

There are three types of ArcSDE geodatabases:   ArcSDE Personal Desktop (SQL Server Express): SQL Server Express,no license required   ArcGIS Server Workgroup (ArcSDE Workgroup):  SQL Server Express, license is required   ArcGIS Server Enterprise (ArcSDE Enterprise): license is required (example: Oracle, SQL Server, DB2, Informix) Types of geodatabases http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//003n00000007000000 What is ArcSDE http://webhelp.esri.com/arcgisdesktop/9.3/index.cfm?TopicName=What_is_ArcSDE? A comparison of geodatabase types http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//003n00000024000000 ... View more

The Create Database User tool correctly displays the error messages in ArcGIS 10.1 service pack "1". In regards to the functionality of turning off the Enforce Password Policy (and requiring the user to change at the next login), please submit the ideal at ArcGIS Ideas web site (http://ideas.arcgis.com/) ... View more

Here are the instructions to run a Python script as a scheduled task in SQL Server: 1. Open SQL Server Management Studio 2. Select SQL Server Agent 3. Right-click on "Jobs" and select "New Job" 4. On the "Steps" page, select "New" (At the bottom of the screen) 5. Select "Operating System (CmdExec)" for the "Type" -- Sample Python script (C:\Python26\HELLO_931.py) import arcpy print 'HELLO' -- Type in the following information in the "Command" window cd C:\Python26 HELLO_931.py ... View more