shilpaprele (1/14/2013)
Is there any way that we can use "SELECT INTO" and still avaoid rowversion dupllication?
YEs you can try like
select "all coumns except rowversion column " into newtable from oldtable
then
alter table newtable add rowverison column
The above is just code hint not the actual sql code
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)