Microsoft KB Archive/196918

= BUG: Comments in Views Removed When Using View Designer =

Article ID: 196918

Article Last Modified on 2/23/2004

-

APPLIES TO


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

-



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.

Keywords: kbbug kbpending KB196918

-

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

© Microsoft Corporation. All rights reserved.