BUG: Comments in Views Removed When Using View Designer (196918)


The information in this article applies to:

  • Microsoft SQL Server 7.0
  • Microsoft SQL Server 2000 (all editions)
This article was previously published under Q196918
BUG #: 50708

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.
Modification Type:MajorLast Reviewed:2/23/2004
Keywords:kbBug kbpending KB196918
©2004 Microsoft Corporation. All rights reserved.