ArcGIS Desktop and SQL SMS not seeing the same values

[WestervilleGIS]

I have 2 Enterprise Databases

Database 1 is a replica (1 way) to Database 2
I go in and make changes (attribute updates) to Database 1.  Save the edits and synchronize the databases.
I load in the data from Database 2 to make sure that the changes are there.  And they are present.

Now I switch over to SQL Server Mgmt Studio and query Database 1 OR Database 2 and the updates are not present.

Any Ideas?

10.1 database
SQL 2008

[AsrujitSengupta]

Courtney,

Reconcile/Post all the versions(if you have any) and then COMPRESS the sde geodatabase. This should reflect the changes in the tables at the database end.

HowTo:  Compress a versioned database to state 0:
http://support.esri.com/en/knowledgebase/techarticles/detail/29160

http://esriaustraliatechblog.wordpress.com/2012/10/08/compressing-the-arcsde-geodatabase/

Regards,

[MarcoBoeringa]

And while you're on it, you may as well consider reading some of the links regarding versioning and data management in a ESRI Geodatabase that I pointed out in this post in another thread, so as to really start understanding it.

Especially the 2004 ESRI Versioning Whitepaper linked there is highly recommended reading, despite it's age.