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 |
|
rams_spl2002
Starting Member
9 Posts |
 Posted - 2007-05-08 : 03:52:17
|
| how would i update identity property.i mean i declared property as identity (1,2).after 10 inserts i want change it as (11,2) is it possible r not? if yes give replay. give replay as early as possible.plz replay to rams_spl2002@yahoo.co.inrams |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-05-08 : 03:58:54
|
| You can make use of DBCC CHECKIDENT with RESEED option to change seed value from 1 to 11.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
rams_spl2002
Starting Member
9 Posts |
Posted - 2007-05-09 : 21:08:08
|
| I WANT TO RESET THE INCREMENT VALUE (1,1)AS (1,2)rams |
|
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-05-10 : 02:13:21
|
| I don't know what exactly you want? In your first post, you told you want to change identity property from (1,2) to (11,2). Now you are saying it should be changed from (1,1) to (1,2).If you want to change the increment value as per your last post, there is no easy way out in SQL 2000 although you can do it in SQL 2005 using simple ALTER TABLE statement.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2007-05-10 : 06:15:24
|
quote:
Originally posted by rams_spl2002
I WANT TO RESET THE INCREMENT VALUE (1,1)AS (1,2)rams
Can you post some sample data with expected result?MadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
identity