This issue is not new to SQL Server 2005 or to views, this problem exists in SQL Server 2000 (not sure in previoius versions). This does not happen all the time, not sure why this happens. Try this,

Create Table table1 (c1 int, c2 int)

Create Table table2 (c3 int, c4 int)

Select *

from table1

where C1 in ( select C1 from table2)

Even though column C1 does not exists, you will not get error.

Yes, I do agree that we as professionals must ensure that sub-query works.

😉