The 'DROP PROCEDURE statement dosen't support local variables in place of procedure name. You'll have to use dynamic SQL.

EXEC('DROP PROCEDURE ' + @SProcName)

>Getting an error:
>
>

>CREATE PROCEDURE sp_ProcExists
>	@SProcName nvarchar(100
>AS
>
>  IF EXISTS (SELECT *
>               FROM dbo.sysobjects
>	       WHERE id = object_id(@SProcName) AND
>	       OBJECTPROPERTY(id, N'IsProcedure') = 1)
>
>     DROP PROCEDURE @SProcName                 <=========== Errors here
>
>