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