SELECT INTO creates the target table, and the only exception along the lines that you are after is with the IDENTITY column.

You could leave the Rowversion column out, as already suggested but we don't know the size of the tables concerned so altering the schema may be a large overhead.

Why not create the target table first and then use INSERT INTO? That will allow what you require.

CREATE TABLE Test1(

Col1 rowversion,

col2VARCHAR(20)

);

CREATE TABLE Test2(

Col1 rowversion,

col2VARCHAR(20)

);

INSERT INTO Test1(col2)

VALUES( 'test1'),( 'test2')

INSERT INTO test2(col2) SELECT Col2 FROM Test1

SELECT * FROM test1;

SELECT * FROM test2;