Identity column lose identity

[wdstar]

I am able to upload my database objects to my account and have it work. But two identity columns in two tables have their identity attribute become false, and the identity seed value gone on my DASP account.

Why is that? Is there anything I can do? The db is SQL 2008 Express on my local machine.

thanks for the help!

[raymondp]

Thats odd, the column properties should have migrated to our SQL server when you use the SQL Management Tool in the control panel. Are you sure that you did not disable the Identity property of the column in your local computer first before you uploaded it to our server? Do any other of your column properties other then the ones you mentioned also have been altered? How did you upload the database to our SQL server, did you use the restore or attach feature?

[wdstar]

I am sure the identity columns on my local computer are set to true. I used Task -> Export data in SSMSE to upload the tables from my local SQL 2008 Express database to my DASP account. Once the tables are uploaded, the identity columens became false automatically.

My only guess is that by uploading the data to DASP, it actually equals t insert value to the identity columns manually, and to do that, the column will be changed to identity false.

I tried many times again, still got the same thing.....

[wisemx]

Hi,
There are many factors that can affect the Identity seeds, Dependency and Range for example.
Take a look at these three articles for some tips, you may spot something:
http://msdn.microsoft.com/en-us/library/ms152543.aspx
http://ryanfarley.com/blog/archive/2004/12/19/1313.aspx
http://geekswithblogs.net/TakeNote/archive/2007/11/30/117258.aspx
All the best,
Mark

[wdstar]

Thanks for your help. I uploaded the tables again...the identity columns work fine now. cheers!

[wisemx]

...Good job. ;-)