Eugene Elutin (7/19/2010)
Other SQL developers may be not generaly using "SELECT * ..." in such situations...
Huh? I don't mean SELECT *
I mean solve the general dependency / refresh problem in SQL Server
especially in the case of hot / online schema changes
OP's issue wasn't the * it was refreshing the view (and dependent objects)
(The refresh idea above won't work properly in many cases)