BUG: Cannot Modify Grouped Stored Procedures in Enterprise Manager

ID: Q229562

The information in this article applies to:

Microsoft SQL Server version 7.0

BUG #: 55334 (SQLBUG_70)

SYMPTOMS

You cannot modify a stored procedure group with SQL Enterprise Manager.

For example, you can create a stored procedure group using the following commands:


use tempdb
go
create proc myproc;1 as select * from sysobjects
go
create proc myproc;2 as select @@version
go

You can execute either stored procedure in the group. However, if you attempt to add a new stored procedure to the group in Enterprise Manager, you will receive the following error message when you click Check Syntax:

Error 156: Incorrect syntax near the keyword 'proc'.

If you ignore that warning, or simply never click Check Syntax, you will receive the following error message when you click Apply or OK:

ERROR 21037: [SQL-DMO]The name specified in the Text property's 'CREATE...' statement must match the Name
property, and must be followed by valid TSQL statements.

WORKAROUND

Use a different tool, such as Query Analyzer, to add a new stored procedure to the group.

STATUS

Microsoft has confirmed this to be a problem in SQL Server version 7.0.

MORE INFORMATION

A procedure can be created with the same name as an existing stored procedure if it is given a different identification number. This allows the procedures to be grouped logically and to be deleted at the same time. For example, the procedures might be named my_proc;1, my_proc;2, and so on. Deleting my_proc deletes the entire group. After procedures have been grouped, individual procedures within the group cannot be deleted.

You can create new grouped stored procedures or delete existing grouped stored procedures in SQL Enterprise Manager, you just cannot modify existing ones.

Additional query words: version group sproc semi-colon revision versioned

Keywords : kbSQLServ700bug
Version : winnt:7.0
Platform : winnt
Issue type : kbbug