Microsoft KB Archive/136473

{|
 * width="100%"|

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

 * }

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 ; 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 ; 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 : kbprogramming kbtool

Issue type : kbbug

Technology : kbSQLServSearch kbAudDeveloper kbSQLServ600