Home > IT Answers > Development > SQL 2008 Identity column values 0
Swetaleena
5 pts.
 SQL 2008 Identity column values 0
SQL, SQL 2008, SQL Identity Column, table identity column
We recently migrated our application from sql 2005(32 bit) to sql 2008(64 bit). I have observed that one of our tables with an identity column is now having all values are 0. I am yet to find out the reason .Could this be related to migration??

Software/Hardware used:
ASKED: April 18, 2009  11:03 AM
UPDATED: April 20, 2009  12:35 PM
RELATED QUESTIONS
Answer Wiki:
Your table would normally have the identity column be the primary key, so that would keep all the values from being the same. SQL doesn't change the actual data of the tables when it upgrades from SQL 2005 to SQL 2008. How are you viewing the data within the table?
Last Wiki Answer Submitted:  April 19, 2009  8:03 am  by  Denny Cherry   64,520 pts.
All Answer Wiki Contributors:  Denny Cherry   64,520 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _