autonumber

Question

Viewing 3 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Mathew J Kulangara SSCommitted Points: 1610 More actions · Answer 1

Not sure if this is the best way to do it..but this works..

select * into #store from {table}

truncate {table}

insert

(non_id fields)

select {non_id fields} from #store

HTH

Andrew Benham Valued Member Points: 58 More actions · Answer 2

From SQL Server Books Online...

DBCC CHECKIDENT ('table_name', RESEED, new_reseed_value)

Enjoy!

Andrew

jcgr SSC Veteran Points: 200 More actions · Answer 3

An easy way is:

Set the autonumber (Identity) in off.

save the table

Set the autonumber (Identity) in on.

Save the table.