Arielr
05-21-2008, 04:36 AM
I need to keep the last number of an autonumeric field after the DB was repared and compacted. Is that posible? Thanks
|
View Full Version : Autonumeric field Arielr 05-21-2008, 04:36 AM I need to keep the last number of an autonumeric field after the DB was repared and compacted. Is that posible? Thanks jdraw 05-21-2008, 05:51 AM I need to keep the last number of an autonumeric field after the DB was repared and compacted. Is that posible? Thanks Just curious, why would you need that? Yes you could keep it. You could put it in a one record table. select max(<autonumbervalue>) from <your table> and place it in the one record table -- but why? |