Microsoft KB Archive/147391

= BUG: DMO Script Method Generates GO Following CREATE INDEX =

Article ID: 147391

Article Last Modified on 3/26/1999

-

APPLIES TO


 * Microsoft SQL Server 6.0 Standard Edition

-



This article was previously published under Q147391



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.

Additional query words: sql6 GO batch

Keywords: KB147391

-

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

© Microsoft Corporation. All rights reserved.