Compact and repair 1

[JKingdom]

hi ..

i was wondering how i can use a similar thing as (compact and repair database )utility what available in MS Access but in SQL .. coz i need to start the auto numbering from 1 again ..

thanks

 

[r937]

access won't reset the autonumber to 1 unless the table is empty when you compact and repair, so you can do the same thing in sql server like this --

TRUNCATE TABLE tablename

this will reset its IDENTITY column to the original seed value

rudy | r937.com | Ask the Expert | Premium SQL Articles
SQL for Database-Driven Web Sites (next course starts May 8 2005)

 

[JKingdom]

thanks alot .. i'll do it this way . but if u know a way that i can do it throught the enterprise manager let me know .. thanks again ..

 

[JKingdom]

thanks .. i've done it through the query analyzer ..