The only best solution which i found through few R & D is to make backup of my database in SQL 2000 and Restore it on SQL 2005. which does not...

Make sure that the compatibility level of Database, In Database properties should be defined for use of lower version then SQL 2005

80 for using SQL 2000

70 for using SQL...

Thanks Steve,

But its not just customer table,

Even my orders,ordersdetail and more tables are having identity column.

and I want a better to way or any idea if identity column can be...

I also faced the same problem as u did,

but to be just better then smart and let the thing work and keep going ahead,I renamed my machine back to old...