Microsoft KB Archive/201868

= PRB: View Designer Errors if Query Cannot Display Graphically =

Article ID: 201868

Article Last Modified on 10/27/2000

-

APPLIES TO


 * Microsoft SQL Server 7.0 Standard Edition

-



This article was previously published under Q201868



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: kbprb KB201868

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.