Microsoft KB Archive/117770

{|
 * width="100%"|

FIX: GUI Tools Using Query Window Don't Retain Text Formatting

 * }

Q117770

-

The information in this article applies to:


 * Microsoft SQL Server Programmer's Toolkit, version 4.21

-

BUG# NT: 10067 (4.21)

SYMPTOMS
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.

CAUSE
Whitespace holders, such as tabs or spaces, that come after a  and before the first character on the new line are not stored in syscomments when run from the Query Window.

WORKAROUND
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.

STATUS
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