Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ITpassenger
Starting Member
6 Posts |
 Posted - 2011-08-09 : 00:51:15
|
| How to reset an AutoNumber field value in SQL server 2005 ??i get the steps in Accessbut what about SQL server DB?? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
ITpassenger
Starting Member
6 Posts |
Posted - 2011-08-09 : 01:15:49
|
| Hi tkizeri mean like this steps but for SQL serverhttp://support.microsoft.com/kb/812718 |
 |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-08-09 : 10:52:51
|
| As Tara said, DBCC CHECKIDENT is what you want.If you want to delete all the data and reset it, then TRUNCATE the table. |
|
|
|
ITpassenger
Starting Member
6 Posts |
Posted - 2011-08-10 : 05:29:05
|
| Thanks russell,i used TRUNCATE and is worked |
|
|
|
|
|
|
reset an AutoNumber field value