BUG: DMO Script() Method Generates GO Following CREATE INDEX

The information in this article applies to:

• Microsoft SQL Server, version 6.0

BUG# NT: 13192 (6.00)

SYMPTOMS

When you use the DMO Script() method to generate scripts for indexes (option SQLOLEScript_Indexes), the script will contain the current command terminator following each CREATE INDEX statement, even if the SQLOLEScript_NoCommandTerm script option is being used.

WORKAROUND

Change the CommandTerminator property of the SQLServer object to an empty string while scripting indexes, then change it back to its previous value after completed.

STATUS

Microsoft has confirmed this to be a problem in Microsoft SQL Server version 6.0. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

MORE INFORMATION

The SQL Server object exposes the CommandTerminator property that can be read or changed using the appropriate Get or Set function. To read the current setting, use GetCommandTerminator(); to set the property, use SetCommandTerminator(). Consult the topic 'Using Property Values' in SQL Server 6.0 "Books Online" for more information on getting and setting properties. Function prototypes are available in the header file SQLOLE.H.