Tag Archives: sql server stored procedure execution phases

Should Stored Procedure name start with SP_ ???

NO, user defined Stored Procedures, should not start with SP_, as this bring down the performance. SQL Server looks for a stored procedure beginning with "sp_" in the following order: MASTER system database use FQN (Fully Qualified Name) to locate the SP if FQN is not supplied, current database is used with dbo as owner [...]