SDE Feature Class Update Problems to Microsoft SQL Server Management Studio

Question

I have a Versioned SDE Point Feature Class that is going to be accessed through Microsoft SQL Server Management Studio to extract the data to update another SQL Database.  When IT did the initial test extraction everything worked fine.  I have been updating my feature class and when the new data is looked at in the SQL Server the updates that I have made is not in the SQL Database.  I did the edits in my version of the feature class and reconciled and posted the data back to the default version.  The changes can be seen in the default version in ArcMAP, but when that database is viewed in SQL it cannot be seen.  So my question is does anybody know what is going on or how to fix this problem?  I am new ArcSDE and SQL so my knowledge of what might be going wrong is limited, so hopefully someone can help me out.

Thanks

JamesFieman · Answer

Six years after, this helped me solve the same issue. Thank you so much Jake!!

ChristopherPounds · Answer

Thanks.  I think the problems we are having are with not properly deleting versions.  Hopefully after the compress runs tonight everything will be working.

jskinner · Answer

Here is a great article that provides steps on compressing a database to state 0:

http://resources.arcgis.com/content/kbase?fa=articleShow&d=29160