BUG: Cannot Modify Grouped Stored Procedures in Enterprise Manager (229562)
The information in this article applies to:
This article was previously published under Q229562
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 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.
| Modification Type: | Major | Last Reviewed: | 10/16/2002 |
|---|
| Keywords: | kbBug KB229562 |
|---|
|