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.