Just like temporary tables in SQL SERVER 2000 you can also create temporary stored procedures.
CREATE PROC #TempProc
@Name nvarchar(50)
AS
SELECT * FROM tblPerson WHERE Name = @Name
DROP PROC #TempProc
All Temp stuff is created under tempdb..sysobjects
SELECT * FROM tempdb..sysobjects will return you #TempProc