Is there anybody using the SQL Server feature to create groups of stored procedures differentiated by number?
Numbered stored procedures are deprecated.


  msdn
  Numbered procedures are deprecated.
  Use of numbered procedures is
  discouraged. A
  DEPRECATION_ANNOUNCEMENT event is
  fired when a query that uses this
  catalog view is compiled.


My team encountered this in a maintenance project. We couldn't figure it out at first. Then, we did some research and found out that it is deprecated. We had to rebuild it to normal stored procs.

Numbered stored procedures won't show up in SSMS's Object Explorer tree.

Numbered Stored Procedures