SA0190 : Numbered stored procedures are deprecated

The topic describes the SA0190 analysis rule.

Message

Numbered stored procedures are deprecated

Description

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.

How to fix

Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

Scope

The rule has a Batch scope and is applied only on the SQL script.

Parameters

Rule has no parameters.

Remarks

The rule does not need Analysis Context or SQL Connection.

Effort To Fix
1 hour per issue.
Categories

Design Rules, Deprecated Features, Bugs

Additional Information

There is no additional info for this rule.

Example Test SQL
SQL
Copy
1CREATE PROCEDURE HumanResources.uspGetAllEmployees ;1 
2AS
3    SET NOCOUNT ON;  
4    SELECT LastName, FirstName, JobTitle, Department  
5    FROM HumanResources.vEmployeeDepartment;
Analysis Results
  Message Line Column
1 SA0190 : Numbered stored procedures are deprecated. 1 51
See Also

Other Resources

Analysis Rules