Code Analysis

DEP020

Page last updated 05 February 2021

Numbered procedures are deprecated

Numbered procedures are deprecated – do not use numbered procedures.

This was always a bad idea that allowed you to overload procedures by creating more than one version of a stored procedure, and which allow you to delete them in one command. It never worked well. 

Available in

 SQL Monitor

SQL Prompt

 SQL Code Guard


Didn't find what you were looking for?

Product Articles

Tips and how-to guides for Redgate products

University

Easy to follow video courses

Community Forums

Ask, discuss, and solve questions about Redgate's tools

Events & Friends

Meet us at an event, get sponsored, and join our Friends of Redgate

Simple Talk

In-depth articles and opinion from Redgate's technical journal