Identity Property problem
 

Hello every body,
Iam santhosh .I need help.Iam using MS Sql server 2000.I have one database.In a column of one table i haved set that to identity property that property generating serial numbers for that table .But that table is not updating.
Table 1
Sno SID Name
1 212 Klen
2 213 Lee
3 215 McGrat
etc..
After few days i want to delete ont row from the table

Table 2
Sno SID Name
2 213 Lee
3 215 McGrat

See that Sno I dont want to see 2,3 I want to see like this

Table 3
Sno SID Name
1 213 Lee
2 2i5 Mc Grat
Iwant to see like this table 3:


I should i do thta .Plss Help me

Re: Identity Property problem
 

You cannot change values in Identity columns - not possible.
If you need to control the values in that particual column(for whatever reason) you need to drop the Identity property and do the whole thing manually.