>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
>
>

>
>
>
>
What exactly is your goal here?

Check http://www.eggheadcafe.com/articles/20030609.asp to generate a script for SP.