>>>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).
>
>That's what I am doing. I am still getting used to Management Studio - I will try doing New Query in the future.
>
>Thanks!
Just keep in mind that all resultsets in New Query window are read-only. You can't edit the values of the fields directly there.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.