Solved

Index full

Posted on 2009-04-12
1
191 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

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…
Introduction: When running hybrid database environments, you often need to query some data from a remote db of any type, while being connected to your MS SQL Server database. Problems start when you try to combine that with some "user input" pass…
Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.

813 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

18 Experts available now in Live!

Get 1:1 Help Now