• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 223
  • Last Modified:

Index full

I use int for primary key and set auto increase.

May I know when it increase and reach the max limit, what will it do?

Stop there or start from 0 again.

Thanks.
0
turbot_yu
Asked:
turbot_yu
1 Solution
 
Kentrix70Commented:
To know the limit of int, you can check this out:

http://forums.asp.net/p/986099/1271198.aspx#1271198

..and about what happens if you reach the limit

http://stackoverflow.com/questions/261815/upper-limit-for-autoincrement-primary-key-in-sql-server

As it is stated on the web page for the last link you can use bigint instead,
which has a REALLY HIGH LIMIT :-)
0

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now