snigdhandream (6/19/2012)
Yes I know, but my problem is... we have a whole DB's tables to be migrated and client is reluctant to creating extra identity columns for DB size issues when i suggested that 🙁
Aham, I understand you,
Why not create the table suggested above as #temp table and then move all the fields from #temp except the identity key, to the destination table?
Regards
IgorMi
Igor Micev,My blog: www.igormicev.com