BUG: DMO Script() Method Generates GO Following CREATE INDEXID: Q147391
|
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.
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.
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.
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 : SSrvDMO SSrvProg
Version : 6.00
Platform : WINDOWS
Issue type :
Last Reviewed: March 24, 1999