AnsweredAssumed Answered


Question asked by fraxinus on Aug 20, 2012
Latest reply on Jun 11, 2014 by sacdou

I have an enterprise database residing in a SQL Server installation that I am accessing through ArcGIS Server 10.1 and ArcGIS Desktop (Advanced) 10.1.

I would need to update a dataset that is in use by a service in the server installation. I can see, using queries to the tables in the SQL Server installation and using the lock manager, that the data is locked, and I can't change anything. If I shut down the Server service on the server machine, or stop the services, then the data is not locked.

In ArcGIS Server 10.0 I just edited service files, and the data was no longer locked. Now I try the method introduced in ArcGIS Server 10.1 - using ArcCatalog, and updating the advanced parameters - setting the schemaLockingEnabled status to false.

But nothing happens - data still locked!

Tried restarting the individual services + the server process - but no luck... !

Any tips?