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

  - 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 <cr><lf> 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.