BUG: Stored Proc Script Generation Has "GO" in Middle

ID: Q136473

The information in this article applies to:

Microsoft SQL Server version 6.0

BUG# NT: 11341 (6.00)

SYMPTOMS

When you generate scripts for a stored procedure from SQL Enterprise Manager (SEM) or from another SQLOLE application, the generated script will contain the word "GO" in the middle of the stored procedure code. This can also occur when you select the "Manage, Stored Procedures" option in SEM.

CAUSE

The problem only occurs when multiple stored procedures have been created using the same name with the <name>;<number> option (for example, sp_addrow;1, sp_addrow;2). This option is used to group stored procedures so that they can be dropped with a single DROP PROCEDURE statement.

WORKAROUND

Create the procedures with separate and distinct names rather than using the <name>;<number> option.

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.

Additional query words: sql6


Keywords          : kbprg kbtool SSrvDMO SSrvEntMan SSrvProg kbbug6.00 
Version           : 6.0
Platform          : WINDOWS 
Issue type        :

Last Reviewed: April 21, 1999