I am working on ArcGIS 10 SP4 with ArcSDE on SQL Server 2008 R2. Our data is using the SQL Server Geometry storage.
When I try to enable archiving on any datasets, it gives me the attached error. The CHECK constraint on the Geometry column is simply checking that shape.srid = 11.
[ATTACH=CONFIG]13865[/ATTACH]
Jeff