LISTING 1: Create Test Procedures in Tempdb

USE tempdb
GO

CREATE PROCEDURE dbo.Select1 AS SELECT 1
GO

CREATE PROCEDURE dbo.sp_Select1 AS SELECT 1
GO