Search Results

That is actually something you will find little documentation on publicly. There are classes/workshops that ESRI charges for or that you can attend at the ESRIUC but less in the public space. A coupl …

I have seen this kind of issue in the past on SQL servers where we had the SDE database run out of space; so then the supporting tables never got all of there updates and crashed. I am not sure of th …

The ESRI commandline tools for ArcSDE are your best option to kill a process or connection without risking a corruption or damage to your Geodatabase. From the looks of what your message says; it doe …

What you are looking for is a Spatial-View, now the only major issue you will see here is that you need to be careful with the fields you are joining on. This is a pretty nice process, I use it all ov …

Yes, a index can be built on it; but you are indexing a long string value so that has some cost but overall you can use that to build a consistent string to join against. Just remember that a GUID by …

You need to define your SDE connection document as you would normally in ArcCatalog; Then you will create the path to the layer in Python like this: DataConnections = "C:\\AGS_GCSS_Tools\\DatabaseCon …

I have done this with my Locations project; where I am building point data; then using C# and normal MSSQL T-SQL StoredProcs to insert the data into a SQL table using Microsoft Geometries. This is act …

Its under your user profile, AppData\Esri\ArcCatalog folder, it varies a little from 9.3.x and 10, but that should get you to the main location. Just look for the .sde files.

The best way I have seen to do it is to use the commandline tools to create the stub of the view; then use the RDBMS tools to expand the view. This allows you to use more visual tools to do this; sinc …

Yes, you can use either a Blob or LONG_RAW per the docs edndocs to support a huge block of text, you really want to make sure you parse your text well before it goes in so you don't have any compromis …

Yes, you can do something like: try: if arcpy.Exists(PropertyTax_Parcels): arcpy.AddMessage("Checking core Layer found? Yes and online") except: raise Exception("Layer not f …

Ok, so I guess this kind of a informal query/survey about how big a datasets you are using in your ESRI worlds... I am building and maintaining a statewide dataset, where I have to process down to the …

The short answer to your question is no. ArcGIS Workgroup edition does not run in the ArcSDE Worker Process; or provide to you the whole toolkit needs to have the sdetable or sdelayer tools or even th …

That isn't a SQL Command, but a DOS/Command Line function you need to use to register the table. You need to launch a command prompt and use your command from after your 'GO' statement to register you …

There are some very good reasons to use a ArcSDE Server Engine, the first being the load. When you utilize a ArcSDE Server Service you are taking the bulk of that data load off the database server and …