In SQL Server 2005 Management Studio, When looking at a view in a SQL Server 2000 Enterprise Edtion (SP4) database I see 1 version in "Edit" and a completely different version of the view in "Design". For example in "Edit" I see something like (which is the same as in SQL Server 2000 "Design"):

SELECT *
From TableA
WHERE ...

In "Design" I see something like this instead:

SELECT Field1, Field2, Field3 AS Field5, Field4 AS Field6, Field5 AS Field7, ...
From TableA
WHERE ...

Most of the fields are being aliased with the names of the other fields in TableA. Has anyone seen this before? Is this documented anywhere?

For further detail the view is dropped and re-created in a SSIS package using Script tasks and Execute SQL tasks.

I know I probably shouldn't use "SELECT *", which was the way the view was created before I arrived, but could this still occur even
if the field names are used? Is this something due to using SSIS on a SQL Server 2000 database?