FIX: GUI Tools Using Query Window Don't Retain Text Formatting |
Q117770
Text formatting is not retained when you execute a CREATE PROCEDURE or
CREATE TRIGGER query from ISQL/W, SQL Administrator, or SQL Object Manager
using the Query Window in Microsoft SQL Server version 4.21.
This problem exists in both 16- and 32-bit versions of the GUI tools, but
does not occur using ISQL.EXE from MS-DOS, Windows NT, or OS/2. The problem
also occurs with version 4.20.50 of the tools.
Whitespace holders, such as tabs or spaces, that come after a <cr><lf> and before the first character on the new line are not stored in syscomments when run from the Query Window.
Use the ISQL.EXE utility to execute queries and retain proper text formatting. You can also use the SQL Object Manager utility by selecting the Manage/Stored Procedure menu option.
Microsoft has confirmed this to be a problem in SQL Server version 4.21. This problem was corrected only in the SQL Server 6.0 tools 32-bit ISQL/W and SQL Enterprise Manager. For more information, contact your primary support provider.
Additional query words: format indentation
Keywords : kbtool
Issue type : kbbug
Technology : kbSQLServSearch kbAudDeveloper
|
Last Reviewed: March 25, 2000 © 2001 Microsoft Corporation. All rights reserved. Terms of Use. |