1
vote
1answer
64 views

Not enough memory in the file group “Primary”: SDE Database error with MSSQL

I got this error message whilst trying to load data into a raster in ArcMap 10.0. Underlying DBMS error [Microsoft SQL Server Native Client 10.0: Eine neue Seite für die sde-Datenbank konnte nicht ...
1
vote
1answer
33 views

Error in GUID fields using “Simple Data Loader”

I have a replicated table in my SQL Server (PE_AMB_ANP), that table has a field named "rowguid" (rowguid is auto generated) When I try yo load data, the field appear matched with 'none', but when the ...
0
votes
0answers
28 views

ArcGIS Full-Text search

I've set up Full-Text searching on a table in my SDE database (ms sql backend). I can perform the full-text commands from SQL queries, but it doesn't seem to work in ArcMap or any rest services. I ...
1
vote
2answers
937 views

How do you create and use a SQL Server spatial view in ArcMap?

All, (using SQL Server 2012, ArcMap 10.1) I have created a SQL spatial statement to test out how a) the union function works, and b) how creating a view of this data will work with ArcGIS. a) the ...
1
vote
0answers
238 views

ArcMap runs custom script once and then it crashes on second run

So I made a script that takes data from an MSSQL database and inserts it into a featureclass. I added the script to a toolbox and am able to run the tool from within ArcMap 10.1. The problem is that ...
2
votes
0answers
322 views

How to build a Query Layer in ArcMap 10.1 using columns of two different databases?

As you may know, to create a Query Layer in ArcMap 10.1, it is required to specify a connection to a concrete database and then, define the access to the tables and columns in the SQL Query ...
4
votes
1answer
152 views

How can I overwrite a geodatabase in AcrGIS server 10 with SQL Server SDE, using xml workspace?

I want to transfer a geodatabase from my development server to my client's production server. We are using SQL Server, but in different versions. Hence I cannot use Backup/restore or detach/attach. ...
3
votes
1answer
199 views

Has anyone been successful using the CAST function in ArcMap 10 with ArcSDE 10

I would like to use the CAST function in the definition query property of a layer and/or in the label class sql query window. This was the most promising link that I've found, including the two links ...
5
votes
1answer
270 views

BigInt data type in SQL Server mapped as Text in ArcMap

I have a table in a SQL Server 2008 database containing a BIGINT data column. When I tried to import it into ArcMap 10, it automatically converted as Text of 8 length. This caused the records that ...
1
vote
0answers
273 views

Cannot join feature layer with SQL Server table with query built in it in ArcMap

I need to join a feature layer with a SQL Server View with a common field in ArcMap. The View was successfully added to ArcMap as data table with some query built on it from Query Builder. When I ...
3
votes
2answers
817 views

SQL Spatial view using a Query Layer in ArcMap 10 is SLOW

We have a number of SQL Spatial views each made up of approximately 10 tables (so relatively complex views) and each including a table with a SQL Geometry column. A view could return up to 300-400 ...
2
votes
0answers
226 views

Updating SDE point feature classes with SQL SERVER 2008 R2 [closed]

I am contacting you in hope that you can help me resolve an issue using SQL Server 2008 R2 to push updates to a SDE point feature class. We are using a C# app that uses ArcGIS Runtime to edit the ...
5
votes
1answer
899 views

How to persist a polygon to SQL Server database and vice versa?

How do I extract all the points from a Polygon drawn in ArcMAP and then persist that data into a SQLServer database table containing a geometry column and then when I've got the data persisted read ...