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

• Microsoft SQL Server, version 6.0

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.