[dba-SQLServer]basic question

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





More information about the dba-SQLServer mailing list