topic SQL server 2008; arcsde 10.1 in Data Management Questions https://community.esri.com/t5/data-management-questions/sql-server-2008-arcsde-10-1/m-p/2802#M171 <HTML><HEAD></HEAD><BODY><SPAN>I have records stuck in Adds, Deletes table.&nbsp; Just default version only no other versions at this time.&nbsp; I can see the updates that I made both in versioned View and ArcMap as well but not when querying the base table in SQL Management studio query.&nbsp; Compress status is successful every time but the updated records can not be seen in SQL since the delta table is not empty.&nbsp; Any suggestions?&nbsp; Thank you in advance.</SPAN></BODY></HTML> Wed, 30 Oct 2013 20:13:03 GMT BC 2013-10-30T20:13:03Z SQL server 2008; arcsde 10.1 https://community.esri.com/t5/data-management-questions/sql-server-2008-arcsde-10-1/m-p/2802#M171 <HTML><HEAD></HEAD><BODY><SPAN>I have records stuck in Adds, Deletes table.&nbsp; Just default version only no other versions at this time.&nbsp; I can see the updates that I made both in versioned View and ArcMap as well but not when querying the base table in SQL Management studio query.&nbsp; Compress status is successful every time but the updated records can not be seen in SQL since the delta table is not empty.&nbsp; Any suggestions?&nbsp; Thank you in advance.</SPAN></BODY></HTML> Wed, 30 Oct 2013 20:13:03 GMT https://community.esri.com/t5/data-management-questions/sql-server-2008-arcsde-10-1/m-p/2802#M171 BC 2013-10-30T20:13:03Z Re: SQL server 2008; arcsde 10.1 https://community.esri.com/t5/data-management-questions/sql-server-2008-arcsde-10-1/m-p/2803#M172 <HTML><HEAD></HEAD><BODY><SPAN>When performing the compress, make sure no users are connected, no locks exist, and all replicas have been synchronized.&nbsp; Also, since you are editing the DEFAULT version, you may want to consider registering your feature class with the option of moving edits to base:</SPAN><BR /><BR /><A href="http://resources.arcgis.com/en/help/main/10.2/index.html#//003n000000rp000000">http://resources.arcgis.com/en/help/main/10.2/index.html#//003n000000rp000000</A><BR /><BR /><SPAN>Checking this option causes edits that have been saved to the DEFAULT&nbsp; version to be&nbsp; saved in the base (business) tables.</SPAN></BODY></HTML> Thu, 31 Oct 2013 12:44:24 GMT https://community.esri.com/t5/data-management-questions/sql-server-2008-arcsde-10-1/m-p/2803#M172 JakeSkinner 2013-10-31T12:44:24Z