September 5, 2008 10:16pm pdt

1. chapmandew 1,956,906
2. angelIII 1,596,212
3. aneeshatti... 555,115
4. mark_wills 553,831
5. ScottPletc... 391,441
6. ee_rlee 349,324
7. acperkins 292,277
8. dtodd 278,051
9. EugeneZ 270,014
10. BrandonG... 192,842
11. Thomasian 153,038
12. cs97jjm3 150,650
13. appari 143,948
14. matthews... 140,203
15. momi_sa... 138,435
16. dbaSQL 127,144
17. brejk 124,990
18. rickchild 121,425
19. ptjcb 119,637
20. dqmq 115,574
21. dportas 112,730
22. bhess1 112,305
23. MohammedU 111,475
24. nmcdermaid 109,818
25. asvforce 103,642

1. angelIII 10,552,625
2. aneeshatti... 4,612,994
3. acperkins 4,280,737
4. ScottPletc... 4,205,493
5. arbert 2,245,195
6. Lowfatsp... 2,165,176
7. chapmandew 1,956,906
8. EugeneZ 1,546,176
9. rafrancisco 1,460,132
10. imran_fast 1,458,963
11. Hilaire 1,221,775
12. Nightman 1,143,404
13. nmcdermaid 1,094,402
14. Mr_Peer... 1,087,815
15. ptjcb 1,053,496
16. bhess1 1,049,297
17. dtodd 864,394
18. Sirees 774,152
19. adathelad 766,312
20. appari 731,185
21. BriCrowe 722,959
22. amit_g 683,229
23. matthews... 662,535
24. ShogunW... 619,598
25. Kevin3NF 590,766

07.21.2005 at 05:51AM PDT, ID: 21499468

	[x] Attachment Details

How to reset identity seed

Asked by metalaureate in MS SQL Server

Tags: identity, reset, seed, mssql

Hi Experts

I have tables whose IDENTITY starts at 100; I use 1 to 99 for Test ID's. So, I frequently have to clean out these tables and start again, during development. What is the easiest way to re-set the IDENTITY SEED? When I try to re-set with the ALTER TABLE statement, MSSQL 2000 still counts from the the last generated value.Start Free Trial

Keywords: How to reset identity seed

	Title
1	Identity Seed Lost after DTS
2	Update Identity seed programatically
3	Need to modify AutoNumber seed by q…
4	SQL 2005 reset seed on a table wit…
5	identity seed and forward engineering
6	identity seed

Loading Advertisement...

20080716-EE-VQP-32

How to reset identity seed

Asked by metalaureate in MS SQL Server

Tags: identity, reset, seed, mssql

About this solution