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 |
|
papu
Starting Member
6 Posts |
 Posted - 2011-10-17 : 05:33:53
|
| Hi when I am running the query in my table it is not giving any error and it is executing successfully.DBCC CHECKIDENT (‘tablename’, NORESEED)DBCC CHECKIDENT ('tablename’, RESEED, 999)And when we are inserting new rows it is taking the value correctly..But when I go to the table and see the design mode it is not reflecting the newly set reseed value in that table in sqlserver 2008.If i will rightclick and select the design in the table it is showing the old reseed value and not updating the new reseed value as (999).Please help me on this ..Thanks in advance.Regards,Papu |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2011-10-17 : 07:10:14
|
It is by design. The seed value from CREATE TABLE is the one stored in the table metadata.
N 56°04'39.26"E 12°55'05.63" |
 |
|
|
papu
Starting Member
6 Posts |
Posted - 2011-10-18 : 04:18:13
|
| BUt in sql server 2005 the table metadata value changes based on the modification. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-10-18 : 04:33:35
|
| why should you try to insert using design view?try to use t-sql query for inserting------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
papu
Starting Member
6 Posts |
Posted - 2011-10-18 : 06:04:53
|
| Yes the value is getting inserted by query only .. but customer wants to see the new seed value in design view..Means . once you reseed the value .. customer wants to see the new value in table , by right click on the table and select the design option..Please help me on this .Thanks for your comments |
|
|
|
|
|
|
DBCC CHECKIDENT