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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-01-12 : 08:30:00
|
| Raj writes "I have SQL server 2000 backend and Ms Access frontend database. And I am not given Add and Drop priviledges.I need to reset the value of the IDENTITY column to zero.I read your thread but it doesnt address the issue to reset the value to a lower number than the maximum value in the column.Can this be done?Thanks for your help,Raj" |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-01-12 : 08:36:54
|
| DBCC CHECKIDENT (TableName, RESEED, -1)Madhivanan |
 |
|
|
|
|
|
reseting IDENTITY column value to zero