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).
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.
Microsoft has confirmed this to be a problem in SQL Server 7.0.