Maximum number of states?

[KobeHarkins]

Hi,

I have a geodatabase that is in SDE 9.3 and SQL 2005. The data is versioned and 5 editors work on it daily. Is there a maximum number of states that can exist in the database? If so, what kind of problems can be created if this maximum number is exceeded? Thank you.

Kobe

[VinceAngelo]

States map to a 32-bit integer (2.14 billion maximum).  You'd run into other issues long
before the number of states became an issue.

- V

[KobeHarkins]

Thank you Vince. We had an incident while I was on vacation where the whole database locked up and no one could edit. The person in charge that day ended up deleting all the versions, compressing the database and restarting the server. The error logs also showed nothing. So everything is fixed but we do not know the cause or if it will return. Thank you for your help.

Kobe

[VinceAngelo]

If it does return, make a snapshot of the database; I'm sure Tech Support would
want a crack at making sure it wouldn't happen a third time.

- V