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 |
|
rubs_65
Posting Yak Master
144 Posts |
 Posted - 2005-02-15 : 11:59:23
|
| Hi,We have a table with identity property for id column that start with 100 and increment by 1.Somehow when we insert into this table(without identity_insert on) it gets the id 1 and not 100….But when I do sp_help it shows identity property as (100,1)…How can we verify that identity property is in effect?Thanks--Harvinder |
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2005-02-15 : 13:28:14
|
| to check the current identity info for a table:dbcc checkident ('MyTable', noreseed)edit:That's strange. The only way I can get that behavior is to create the table with identity (100,1), then explicitly reseed to 0 using dbcc checkident with reseed. sp_help still shows (100,1) but an insert and dbcc checkident shows 1. As far as I know you can't "turn off" the identity functionality without altering the table. Are you sure you don't have 2 versions of the same table out there with different owners ie: dbo.MyTable and User1.MyTable?Be One with the OptimizerTG |
 |
|
|
|
|
|
identity problem