SQL Server data type

Results 1 to 2 of 2

Thread: SQL Server data type

  1. #1
    Join Date
    Dec 1969

    Default SQL Server data type

    I have a table and the PrimaryID field datatype is set to BigInt, Identity set to &#039;Yes, no replication&#039;, inc by 1.<BR><BR>My question is, I delete old ID&#039;s which are old to save space, but the auto increment will keep incrementing.<BR><BR>At what time does the DB stop dishing out ID&#039;s, i.e 9999999999<BR><BR>Or do you have to compact to db like access??

  2. #2
    Join Date
    Dec 1969

    Default RE: SQL Server data type

    I believe it will keep on until it reaches the maximum for the field type. I *think* you can reset the counter by turning off the seed, saving, then turning it back on. I don&#039;t know what that&#039;d do to any existing ID&#039;s in the db though...<BR><BR>Tim

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts