If dbcc upgrade_object reports the existence of select * in a view, compare the output of syscolumns for the original view to the output of the table, to determine whether columns have been added to or deleted from the table since the view was created.
create view all_emps as select * from employees
Do not execute a select * statement from the view. Doing so upgrades the view and overwrites the information about the original column information in syscolumns.
select name from syscolumns where id = object_id("all_emps") select name from syscolumns where id = object_id("employees")