>>>If only one table is used in a query, why do you need to use table's name referring to its columns?
>>>
>>>Also, could it be case-sensitive installation of SQL Server?
>>
>>:-)
>>This is an example, not the full query.
>>No, nothing on this server is case or accent sensitive.
>
>For multi-table queries I normally use aliases so never faced this problem.

Usually me too :-)
but sometimes I forgot and on my computer queries work.
That is why I want to turn tis off so, on my machine they bomb as it should be :-)