Hi,

I have actually tried to select eveything into a temp table. The select into works fine, and if I do a select count(*) there are no problems.

However if I do a select * on either table , the original OR the temp table I get that error.

If I do only a partial select its fine. IE. If I select top 1000 * from Table.

The table contains  a few million rows. So granted it is a lot of information to Select * , but the error message just seems somewhat unrelated to what I'm trying to do.

Unless somewhere in the background SQL actually replaces some text, and runs into an error. 

Do you have any idea, why it would try to replace the text?

Thanks again.