BUG: DMO Script() Method Generates GO Following CREATE INDEX (147391)
The information in this article applies to:
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.
Modification Type: | Major | Last Reviewed: | 3/26/1999 |
---|
Keywords: | KB147391 |
---|
|