>In a query windows in Management Studio if I type a query like SELECT * FROM Table1 it transforms it to SELECT field1, field2, field3 FROM Table1. Is there a way to turn that off?
When you open table for editing "Right click on table->Open" and then open SQL Window and type your query, I think this is not possible.
When you press "New Query" and then type your query nothing is changed (at least here on my computer).
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.