I think the best solution is to remove SQL Server, reinstall it and then run the SP3a service pack to get it updated to the most current.

Also, you never said...

Is the column name really "Note                             "?

If you look at the DTS error, it does not like all the spaces after the word Note.

I have not use Analysis Services, but I have designed a number of data warehouses in other dbs.

A dimension table is highly denormalized and should not require any joins to...

In the register wizard for Enterprise Manager, it lists the SQL Servers that are available. 

Is yours listed?

What version of SQL Server did you install?

Have you installed any of the...

I am not sure about Visio.  I would think that the Visio for Enterprise Architect would do some of these things.  You might also check out Quest Software for their...

Actually, the upsizing wizard is not a very good tool to use.  It is the best one if you do not have quality tools, like ERWin Data Modeler.  But, After...

Try using (local) for the name of the server.

Are you looking for a data dictionary, or a metadata repository? For a data dictionary, you can extract all the information with tools like ERWin and then load a...

Another method is to detach the database and copy it to the CD. Then reattach it locally.