topic Re: Maximum number of states? in Data Management Questions https://community.esri.com/t5/data-management-questions/maximum-number-of-states/m-p/583692#M33010 <HTML><HEAD></HEAD><BODY><SPAN>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.</SPAN><BR /><BR /><SPAN>Kobe</SPAN></BODY></HTML> Mon, 24 Jan 2011 15:31:40 GMT KobeHarkins 2011-01-24T15:31:40Z Maximum number of states? https://community.esri.com/t5/data-management-questions/maximum-number-of-states/m-p/583690#M33008 <HTML><HEAD></HEAD><BODY><SPAN>Hi,</SPAN><BR /><BR /><SPAN>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.</SPAN><BR /><BR /><SPAN>Kobe</SPAN></BODY></HTML> Fri, 21 Jan 2011 14:28:08 GMT https://community.esri.com/t5/data-management-questions/maximum-number-of-states/m-p/583690#M33008 KobeHarkins 2011-01-21T14:28:08Z Re: Maximum number of states? https://community.esri.com/t5/data-management-questions/maximum-number-of-states/m-p/583691#M33009 <HTML><HEAD></HEAD><BODY><SPAN>States map to a 32-bit integer (2.14 billion maximum).&nbsp; You'd run into other issues long</SPAN><BR /><SPAN>before the number of states became an issue.</SPAN><BR /><SPAN> </SPAN><BR /><SPAN>- V</SPAN></BODY></HTML> Fri, 21 Jan 2011 15:06:54 GMT https://community.esri.com/t5/data-management-questions/maximum-number-of-states/m-p/583691#M33009 VinceAngelo 2011-01-21T15:06:54Z Re: Maximum number of states? https://community.esri.com/t5/data-management-questions/maximum-number-of-states/m-p/583692#M33010 <HTML><HEAD></HEAD><BODY><SPAN>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.</SPAN><BR /><BR /><SPAN>Kobe</SPAN></BODY></HTML> Mon, 24 Jan 2011 15:31:40 GMT https://community.esri.com/t5/data-management-questions/maximum-number-of-states/m-p/583692#M33010 KobeHarkins 2011-01-24T15:31:40Z Re: Maximum number of states? https://community.esri.com/t5/data-management-questions/maximum-number-of-states/m-p/583693#M33011 <HTML><HEAD></HEAD><BODY><SPAN>If it does return, make a snapshot of the database; I'm sure Tech Support would</SPAN><BR /><SPAN>want a crack at making sure it wouldn't happen a third time.</SPAN><BR /><SPAN> </SPAN><BR /><SPAN>- V</SPAN></BODY></HTML> Mon, 24 Jan 2011 16:04:05 GMT https://community.esri.com/t5/data-management-questions/maximum-number-of-states/m-p/583693#M33011 VinceAngelo 2011-01-24T16:04:05Z