artullman

"Wrong Column Type" trying to create a Feature class in non-SDE SQL Server with 10.1

Discussion created by artullman on Nov 5, 2013
Latest reply on Nov 6, 2013 by artullman
I have a brand new empty SQL Server 2008 R2 database.  I am trying to either load data from an FGDB or create a new Feature Class using ArcCatalog.  Every time I try to perform either function, I get an error:  Wrong Column Type and 00210 error.

When I run the SQL Profiler, I can see that the following SQL executes correctly in SQL, but then I see a DROP TABLE immediately after this step:

CREATE TABLE GISMART_TST.dbo.aaaaa ( OBJECTID INTEGER NOT NULL IDENTITY ,  SHAPE geometry NULL, PRIMARY KEY ( OBJECTID) )

I am running Microsoft SQL Server 2008 R2 (SP1) - 10.50.2500.0 (X64)  and ArcCatalog 10.1 with SP1.

I have done this plenty of times at other installations without problems.  My license is Desktop Standard.  In the past, I have had ArcGIS Advanced License.   I don't think this should make a difference.

Outcomes