When we had the SDE running and when we added a geometry type that was say, a line, ONLY a line datatype would appear in the Task Pane window. The exact same data is loaded on to the SQL Server Spatial database and we get all three (2 are invalid) data types showing in the Task Pane. Our ArcGis users get only the proper data type once they load the same data without having to set a schema. The underlying question is why?
(The suggestion of doing a bulk copy is not practical as we get data updates very often which means we would have to bulk copy those to stay current. Further, why would we want to spend twice as much time administering two databases when the CAD and GIS users can share one?)
We in the CAD group do not export data to create our server database. We get the overwhelming majority of our shared (between GIS and CAD) data from outside (vendor) sources. We had this same data on a SDE database connection that we used to be able to access (before Civil 2013). Now, when we access the SQL Server Spatial database we get the three data types. In other words we didn't have to set up schemas on the SDE (or even burden ourselves with a bulk copy) and why is it we can't get the single data type as the ArcGis users do? They don't 'bulk copy' the data from the server either in the SDE or SQl Server servers. Why should we?
Beginning with ArcGIS 9.3, geodatabases stored in a SQL Server 2008 database can use the Microsoft geometry or geography storage types for feature storage. Feature classes that use one of these storage types also have a business table, as described in the previous section. However, for this storage type, the business table contains a column of type GEOMETRY or GEOGRAPHY, in which the feature class geometry is stored; there is no associated feature table.
Feature class tables that use geometry or geography storage also have associated system tables plus associated views. Click the following link to see a diagram of a feature class that uses the Microsoft geometry or geography storage type.
In the diagram, the feature class business table, buildings, is linked to the system tables by way of the table name
Access a broad range of knowledge to help get the most out of your products and services.