Identity in a field

[M J Jaya Chitra]

Dear All, I have a question regarding the usage of IDENTITY. Can any one answer me? My Question is: Whenever the primary key field is having an auto generated value i.e. IDENTITY. If any overflow occurs i.e. when the fields reaches its maximum value, what will happen? Thanks in advance.

Best Regards, M. J. Jaya Chitra

[KANGAROO_]

obviously it will generate an error......... :)

manoj Kumar Jha "Learn to smile at every situation. See it as an opportunity to prove your strength and ability."

[M J Jaya Chitra]

Practically, how can be get rid of this error?

Best Regards, M. J. Jaya Chitra

[Dave Kreskowiak]

Change the datatype of the ID field to one that holds values bigger than the one you have now.

A guide to posting questions on CodeProject[^]
Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic
     2006, 2007

[M J Jaya Chitra]

Already my data type is big int. My application is going to store voluminous transactions in the database.

Best Regards, M. J. Jaya Chitra

[vimal_yet]

Then use GUID in SQL Server. by using the function newid()

If U Get Errors U Will Learn If U Don't Get Errors U Have Learnt

[Dave Kreskowiak]

BigInt and you think you're going to run out of IDs?? You can't possibly tell me that your table is going to hold more than 9,223,372,036,854,775,807 (time 2 for negative numbers) records. I'd like to see the storage drive array that's going to hold this database, not to mention the backup scheme you've got.

A guide to posting questions on CodeProject[^]
Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic
     2006, 2007