since in SQL, use MSSQL Server Management Studio...
use <your database> select name, owner, version_id, state_id, parent_name, parent_owner from [<your database>].[dbo].[SDE_versions] select * from [<your database>].[dbo].[SDE_versions] select * from [<your database>].[dbo].[SDE_states] order by state_id select * from [<your database>].[dbo].[sde_state_lineages] order by lineage_name, lineage_id |
You may need to use a different name than DBO, depending on your setup. I've included the info if/when you do versioning, but you may not need those lines. I look at the number of rows that are listed in the lower right, and when it gets +150 or more (depending), and we're reconciled/posted our versions, I do the compress.
Good to look before the compress. the run it again afteer to see the recod count change.
These lines are informational only....nothing is changed in the database (compress does change things.)