PRB: View Designer Errors if Query Cannot Display Graphically

SYMPTOMS

The SQL Enterprise Manager View Designer gives errors if a query cannot be displayed graphically.

For example, when you create a view with the following query:

   SELECT cast(au_id AS varchar(5))
   FROM authors
				

You receive the following error when you execute the query: If you click Yes, the view is created and the results are returned in the Results pane, but there is no graphical display in the Diagram or Grid panes.