Thought about that too, but if the source table changed since the first snapshot and you needed to preserve that point in time that would not work

***Here is what Microsoft had to say on this***

Be interesting to see if anyone has found a workaround

The no rename restriction is not limited to snapshots. The restriction is...

I was not the one that ask the question so whether I or you for that matter want to do it is not relevant.

As for the interview comment there...

True,

except it does not statisfy the requirements of the question

the question was:

how can we copy one database table to another DB table without script and insert statement

Not sure why you are surprised , we use it all the time. I agree that this is not the medthod of choice for large record counts but it still...

You could right click and open the table using Management Studio. Click in upper most left hand corner to highlight all records and right click copy. You would then open...