[dba-SQLServer]basic question

Look up DBCC CHECKIDENT in BOL

Billy


>From: "Susan Harkins" <harkins at iglou.com>
>Reply-To: dba-sqlserver at databaseadvisors.com
>To: "SQLList" <dba-SQLServer at databaseadvisors.com>
>Subject: [dba-SQLServer]basic question
>Date: Tue, 18 Mar 2003 19:39:37 -0500
>
>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
>


_________________________________________________________________
Add photos to your e-mail with MSN 8. Get 2 months FREE*.  
http://join.msn.com/?page=features/featuredemail