I have records stuck in Adds, Deletes table. Just default version only no other versions at this time. 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. Compress status is successful every time but the updated records can not be seen in SQL since the delta table is not empty. Any suggestions? Thank you in advance.
When performing the compress, make sure no users are connected, no locks exist, and all replicas have been synchronized. 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: