# SQL Server Rule: SRN0002
| | |
|----|----|
| Assembly | SqlServer.Rules |
| Namespace | SqlServer.Rules.Naming |
| Class | AvoidSPPrefixRule |
## Rule Information
| | |
|----|----|
| Id | SRN0002 |
| Friendly Name | Procedure name may conflict system name |
| Category | Naming |
| Ignorable | true |
| Applicable Types | Procedure |
## Description
Avoid 'sp_' prefix when naming stored procedures.
## Summary
Avoid 'sp_' prefix when naming stored procedures.
### Remarks
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.
<sub><sup>Generated by a tool</sup></sub>
