DF194: Stored procedure name begins with ‘sp_’.

Last modified: December 25, 2024

The topic describes the DF194 T-SQL code analysis rule.

Category

BEST PRACTICE

Message

Stored procedure name begins with ‘sp_’.

Description

It is recommended not to start the procedure name with ‘sp_’ as this prefix is commonly reserved for system stored procedures.

Noncompliant code example

CREATE PROCEDURE dbo.sp_DemoProc
AS
BEGIN
  SET NOCOUNT ON;
  SELECT id FROM dbo.DemoTable;
END
GO

Compliant solution

CREATE PROCEDURE dbo.DemoProc
AS
BEGIN
  SET NOCOUNT ON;
  SELECT id FROM dbo.DemoTable;
END
GO