<?xml version="1.0" ?><html>
<head>
<title></title>
</head>
<body>
<div align="left"><font face="Arial"><span style="font-size:10pt">In Enterprise Manager, go into Design
Table, deselect "Identity" and save the definition, then open it again and
re-select it. Voila!</span></font></div>
<div align="left"><br/>
</div>
<div align="left"><font face="Arial"><span style="font-size:10pt">Note that, unlike Access, you can
also re-use deleted Identity values. From BOL:</span></font></div>
<div align="left"><br/></div>
<div align="left"><font face="Arial"><span style="font-size:10pt">"By default, data cannot be inserted
directly into an identity column. The identity column generates a unique,
sequential number automatically for each new row inserted in the table. This default can be overridden
using
the following SET statement: </span></font></div>
<div align="left"><br/></div>
<div align="left"><font face="Arial"><span style="font-size:10pt">SET IDENTITY_INSERT table_name ON</span></font></div>
<div align="left"><br/></div>
<div align="left"><font face="Arial"><span style="font-size:10pt">With IDENTITY_INSERT set to ON, the
user is allowed to insert any value into a new row with an identity
column. To prevent the entry of duplicate numbers, a unique index must be created against the column.
The
purpose of this statement is to allow a user to re-create a value for a row that has been deleted accidentally. </span></font></div>
<div align="left"><br/></div>
<div align="left"><br/>
</div>
<div align="left"><font face="Arial"><span style="font-size:10pt">On 18 Mar 2003 at 22:48, Antony, Fredrick
wrote:</span></font></div>
<div align="left"><br/>
</div>
<div align="left"><font face="Arial" color="#7f0000"><span style="font-size:10pt">> No Identity is
meant for identical value. There is no way of resetting it </span></font></div>
<div align="left"><font face="Arial" color="#7f0000"><span style="font-size:10pt">> </span></font></div>
<div align="left"><font face="Arial" color="#7f0000"><span style="font-size:10pt">> Regards</span></font></div>
<div align="left"><font face="Arial" color="#7f0000"><span style="font-size:10pt">> Fred</span></font></div>
<div align="left"><font face="Arial" color="#7f0000"><span style="font-size:10pt">> </span></font></div>
<div align="left"><font face="Arial" color="#7f0000"><span style="font-size:10pt">> -----Original
Message-----</span></font></div>
<div align="left"><font face="Arial" color="#7f0000"><span style="font-size:10pt">> From: Susan Harkins
[mailto:harkins@iglou.com]</span></font></div>
<div align="left"><font face="Arial" color="#7f0000"><span style="font-size:10pt">> Sent: Wednesday,
March 19, 2003 6:10 AM</span></font></div>
<div align="left"><font face="Arial" color="#7f0000"><span style="font-size:10pt">> To: SQLList</span></font></div>
<div align="left"><font face="Arial" color="#7f0000"><span style="font-size:10pt">> Subject: [dba-SQLServer]basic
question</span></font></div>
<div align="left"><font face="Arial" color="#7f0000"><span style="font-size:10pt">> </span></font></div>
<div align="left"><font face="Arial" color="#7f0000"><span style="font-size:10pt">> </span></font></div>
<div align="left"><font face="Arial" color="#7f0000"><span style="font-size:10pt">> In Access, a
compact will reset the AutoNumber seed value to one more than</span></font></div>
<div align="left"><font face="Arial" color="#7f0000"><span style="font-size:10pt">> the largest AN
value already in the table. Is there anyway to do this with</span></font></div>
<div align="left"><font face="Arial" color="#7f0000"><span style="font-size:10pt">> an Identity column
in SQL Server?</span></font></div>
<div align="left"><font face="Arial" color="#7f0000"><span style="font-size:10pt">> </span></font></div>
<div align="left"><font face="Arial" color="#7f0000"><span style="font-size:10pt">> Susan H.</span></font></div>
<div align="left"><font face="Arial" color="#7f0000"><span style="font-size:10pt">> </span></font></div>
<div align="left"><font face="Arial" color="#7f0000"><span style="font-size:10pt">> _______________________________________________</span></font></div>
<div align="left"><font face="Arial" color="#7f0000"><span style="font-size:10pt">> dba-SQLServer
mailing list</span></font></div>
<div align="left"><font face="Arial" color="#7f0000"><span style="font-size:10pt">> dba-SQLServer@databaseadvisors.com</span></font></div>
<div align="left"><font face="Arial" color="#7f0000"><span style="font-size:10pt">> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver</span></font></div>
<div align="left"><font face="Arial" color="#7f0000"><span style="font-size:10pt">> http://www.databaseadvisors.com</span></font></div>
<div align="left"><font face="Arial" color="#7f0000"><span style="font-size:10pt">> </span></font></div>
<div align="left"><font face="Arial" color="#7f0000"><span style="font-size:10pt">> </span></font></div>
<div align="left"><font face="Arial" color="#7f0000"><span style="font-size:10pt">> _______________________________________________</span></font></div>
<div align="left"><font face="Arial" color="#7f0000"><span style="font-size:10pt">> dba-SQLServer
mailing list</span></font></div>
<div align="left"><font face="Arial" color="#7f0000"><span style="font-size:10pt">> dba-SQLServer@databaseadvisors.com</span></font></div>
<div align="left"><font face="Arial" color="#7f0000"><span style="font-size:10pt">> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver</span></font></div>
<div align="left"><font face="Arial" color="#7f0000"><span style="font-size:10pt">> http://www.databaseadvisors.com</span></font></div>
<div align="left"><font face="Arial" color="#7f0000"><span style="font-size:10pt">> </span></font></div>
<div align="left"><br/>
</div>
<div align="left"><br/>
</div>
<div align="left"><font face="Arial"><span style="font-size:10pt">-- </span></font></div>
<div align="left"><font face="Arial"><span style="font-size:10pt">Stuart McLachlan</span></font></div>
<div align="left"><font face="Arial"><span style="font-size:10pt">Lexacorp Ltd</span></font></div>
<div align="left"><font face="Arial"><span style="font-size:10pt">Application Development, IT
Consultancy</span></font></div>
<div align="left"><font face="Arial"><span style="font-size:10pt">http://www.lexacorp.com.pg</span></font></div>
<div align="left"></div>
</body>
</html>