DetailPage-MSS-KB

Microsoft small business knowledge base

Article ID: 290536 - Last Review: November 2, 2013 - Revision: 2.0

This article was previously published under Q290536
This article has been archived. It is offered "as is" and will no longer be updated.
BUG #: 57796 (SQLBUG_70)

On This Page

Symptoms

In the SQL Server Enterprise Manager, when loading a view into the View Designer, the diagram, grid, and result panes are empty and the SQL pane contains an incorrect SELECT statement if the CREATE VIEW statement is longer than 3.5 kilobytes (KB).

Workaround

To work around this issue and avoid the problem, use any one of the methods that follow:
  • Keep the CREATE VIEW statement shorter than 3.5 KB.

  • Use the SQL Server Query Analyzer instead of Enterprise Manager to design the view.

  • In Enterprise Manager, load the view into the Properties dialog box and the statement displays correctly. Copy the CREATE VIEW statement to the Clipboard (exclude the CREATE VIEW part itself, that is, begin with the SELECT keyword). Open the view with View Designer, navigate to the SQL area and replace the incorrect statement by pasting the correct statement from the Clipboard. Press the Verify SQL command button. The diagram, grid, and result panes then display correctly.

  • Upgrade your Enterprise Manager to the version that was provided with Microsoft SQL Server 2000. The problem does not occur with SQL Server 2000, even when you work on a SQL Server 7.0 engine.

Status

Microsoft has confirmed this to be a problem in SQL Server 7.0.

More information

Steps To Reproduce Behavior

  1. Create a view that has a CREATE VIEW statement string longer than 3.5 KB.
  2. In Enterprise Manager, select the view, open the context menu, and then click Design View. The Design View dialog box shows an empty diagram, grid, and results pane. Also, the SQL pane contains an incorrect SELECT statement.NOTE: The length of the CREATE VIEW statement string has to be calculated excluding comments. This problem does not occur if the statement string contains 3.5 KB text plus any amount of comments.

Applies to
  • Microsoft SQL Server 7.0 Standard Edition
Keywords: 
kbnosurvey kbarchive kbbug kbDSupport KB290536
Share
Additional support options
Ask The Microsoft Small Business Support Community
Contact Microsoft Small Business Support
Find Microsoft Small Business Support Certified Partner
Find a Microsoft Store For In-Person Small Business Support