I have been trying to register a SQL Server 2008 table with a 'date' field as a point feature class in SDE 10. When I try to register the table I get the following error.sdelayer -o register -l test,geom -e p -t geography -R 1 -i sde:sqlserver:localhost,1276 -D <%databasename%> -E -180,-90,+180,+90 -u <%user%> -p <%password%> ArcSDE 10.0 for SQL Server Build 685 Fri May 14 12:05:43 2010 Layer Administration Utility ----------------------------------------------------- Error: Attribute conversion error (-55). Error: Unable to create registration for table test.
If I remove the 2 date fields, change them to datetime or datetime2 then the table registers just fine.I have seen here that SDE uses the datetime field and does not mention that the date field is NOT supported.http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#/A_comparison_of_ArcGIS_ArcSDE_and_SQL_Server_data_types/002q00000068000000/But it also says When you create a feature class or table in ArcGIS, there are 11 possible data types you can assign to a field. That means there are some data types that can only be created outside ArcGIS.
leading me to think that I can use the date field as long as the table is created outside of SDE, which it is.
