PRB: View Designer Errors if Query Cannot Display Graphically

ID: Q201868

The information in this article applies to:

Microsoft SQL Server version 7.0

BUG #: 49469 (SQLBUG_70)

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:

AS is not supported

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.

CAUSE

Enterprise Manager shows this behavior when you enter a query in the SQL pane that cannot be displayed graphically. You have the option of undoing the changes or allowing the changes but not being able to graphically edit the query in the future.

WORKAROUND

Hide the Grid and Diagram panes and the error does not appear.

Additional query words: prodsql

Keywords : kbSQLServ700
Version : winnt:7.0
Platform : winnt
Issue type : kbprb