Microsoft KB Archive/229562

= BUG: Cannot Modify Grouped Stored Procedures in Enterprise Manager =

Article ID: 229562

Article Last Modified on 10/16/2002

-

APPLIES TO


 * Microsoft SQL Server 7.0 Standard Edition

-



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.

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

Keywords: kbbug kbpending KB229562

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.