Susan Harkins
harkins at iglou.com
Tue Mar 18 18:39:37 CST 2003
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.