Knowledge Base

BUG: Comments in Views Removed When Using View Designer

Article ID: 196918

Article Last Modified on 2/23/2004

Microsoft SQL Server 7.0 Standard Edition
Microsoft SQL Server 2000 Standard Edition

This article was previously published under Q196918

SYMPTOMS

When using the View Designer to create or edit views, any comments that were embedded in the SQL code will be removed when the query is saved or run.

WORKAROUND

To work around this problem, use a manually written script (with the appropriate comments inserted) to create the view.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

Keywords: kbbug kbpending KB196918