SA0015 : Avoid ‘sp_’ prefix when naming stored procedures
The topic describes the SA0015 analysis rule.
Avoid ‘sp_’ prefix when naming stored procedures
This rule checks for creation of stored procedure with names starting with “sp_”.The prefix sp_ is reserved for system stored procedure that ship with SQL Server.
Whenever SQL Server encounters a procedure name starting with sp_, it first tries to locate the procedure in the master database, then it looks for any qualifiers (database, owner) provided, then it tries dbo as the owner. So you can really save time in locating the stored procedure by avoiding the “sp_” prefix.
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.
Naming Rules, Bugs
There is no additional info for this rule.
1-- The 'sp_' stored procedure name prefix is reserved for system procedures and should be avoided 2CREATE PROCEDURE sp_uspGetAllEmployees 3AS 4 SET NOCOUNT ON; 5 SELECT LastName, FirstName, JobTitle, Department 6 FROM HumanResources.vEmployeeDepartment;
|1||SA0015 : Avoid ‘sp_’ prefix when naming stored procedures.||2||17|