I found the problem with onliy 11 rows being copied.  It seems to lie in the SQL Server Administrator my host provides online to execute single commands and test.  When...

I'm back....

The $135/hr consultant is telling me that when copying a table as I'm doing, the columns have to be in the same order.

Is this true?

If so, how do I ensure...

Thanks for continuing to help RGR'us.  I get 155 records from the select only.  When I look at the actual records returned, I stop at 20 or so counting and...

It's the weirdest thing.  even using "select * into table2 from table1", I only get 11 records in my table.

I get no errors either.  I'm typing it into the SQL Server Database...