Solved

Index full

Posted on 2009-04-12
1
174 Views
Last Modified: 2012-05-06
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
Comment
Question by:turbot_yu
1 Comment
 
LVL 6

Accepted Solution

by:
Kentrix70 earned 500 total points
ID: 24128337
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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Join & Write a Comment

Suggested Solutions

If you having speed problem in loading SQL Server Management Studio, try to uncheck these options in your internet browser (IE -> Internet Options / Advanced / Security):    . Check for publisher's certificate revocation    . Check for server ce…
I am showing a way to read/import the excel data in table using SQL server 2005... Suppose there is an Excel file "Book1" at location "C:\temp" with column "First Name" and "Last Name". Now to import this Excel data into the table, we will use…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…

708 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now