Antony, Fredrick
Fredrick_Antony at Dell.com
Tue Mar 18 22:48:30 CST 2003
No Identity is meant for identical value. There is no way of resetting it Regards Fred -----Original Message----- From: Susan Harkins [mailto:harkins at iglou.com] Sent: Wednesday, March 19, 2003 6:10 AM To: SQLList Subject: [dba-SQLServer]basic question In Access, a compact will reset the AutoNumber seed value to one more than the largest AN value already in the table. Is there anyway to do this with an Identity column in SQL Server? Susan H. _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com