Djabarov, Robert
Robert.Djabarov at usaa.com
Wed Mar 19 09:16:28 CST 2003
Actually, truncating the table resets the identity column to start from the number specified in SEED. Robert Djabarov Senior SQL Server DBA USAA IT/DBMS ? (210) 913-3148 - phone ? (210) 753-3148 - pager -----Original Message----- From: Antony, Fredrick [mailto:Fredrick_Antony at dell.com] Sent: Tuesday, March 18, 2003 10:49 PM To: dba-sqlserver at databaseadvisors.com Subject: RE: [dba-SQLServer]basic question 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 _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com