SA0190 : Numbered stored procedures are deprecated
The topic describes the SA0190 analysis rule.
Numbered stored procedures are deprecated
The rule checks for creation of numbered stored procedures.
The numbered stored procedure feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.
The rule has a Batch scope and is applied only on the SQL script.
Rule has no parameters.
The rule does not need Analysis Context or SQL Connection.
Design Rules, Deprecated Features, Bugs
There is no additional info for this rule.
1CREATE PROCEDURE HumanResources.uspGetAllEmployees ;1 2AS 3 SET NOCOUNT ON; 4 SELECT LastName, FirstName, JobTitle, Department 5 FROM HumanResources.vEmployeeDepartment;
|1||SA0190 : Numbered stored procedures are deprecated.||1||51|