Prior ArcSDE 9.3 was a Tool called Check Schema to see, if there’s any inconsistency in ArcSDE. Now we have nothing to see if the ArcSDE Repository contains the necessary Records corresponding to the Objects stored in the User-Schemas and so on. For an Enterprise Geodatabase as ArcSDE a Tool like Check Schema is a must!