What is purpose of semi colon after procedure name

[jw56578]

I've seen some system sp's that have a semi colon and number after the
the name such as
create procedure sp_procedure_params_rowset;2
what does this do?

[Gert E.R. Drapers]

This is a versioning mechanism, see BOL CREAT E PROCEDURE

http://msdn.microsoft.com/library/de...reate_4hk5.asp

;number

Is an optional integer used to group procedures of the same name so they can
be dropped together with a single DROP PROCEDURE statement. For example, the
procedures used with an application called orders may be named orderproc;1,
orderproc;2, and so on. The statement DROP PROCEDURE orderproc drops the
entire group. If the name contains delimited identifiers, the number should
not be included as part of the identifier; use the appropriate delimiter
around procedure_name only.

Ge***@SQLDev.Net

Please reply only to the newsgroups.
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use.
Copyright © SQLDev.Net 1991-2005 All rights reserved.

<jw*****@gmail.com> wrote in message
news:11*********************@g49g2000cwa.googlegro ups.com...

I've seen some system sp's that have a semi colon and number after the
the name such as
create procedure sp_procedure_params_rowset;2
what does this do?