Does anyone know if ArcGIS honors MSSQL relationships that are not built in SDE? How about general MSSQL column types. In the grand scheme I think SDE limits the types to few where MSSQL choices are many. I would like to see ArcSDE and MSSQL make use of dbms for non spatial data, i.e. a parcel feature class (SDE) related to CAMA data (non SDE) without having to build a spatial view.