Check if stored proc exists in DB? ~ Beginner School

I am trying to execute scripts of procedures in another database. The problem is this stored procedure exist or not in database. For handling this problem, I wrote following script which checks if stored proc exists in database and if does then provide execute for user?

Try this:

IF EXISTS (SELECT * FROM dbo.sysobjects 
      WHERE id = object_id(N'[dbo].[your_procedure_name]') 
      and OBJECTPROPERTY(id, N'IsProcedure') = 1)
      BEGIN
          -- Set privileges here
      END

Try this:

if exists (select 1
      from sysobjects
      where  id = object_id('YourProc')
      and type = 'P')

About Admin

Beginner School is optimized for learning. This is useful for getting basic knowledge with easiest way. Tutorials, examples are constantly reviewed to avoid errors, but we cannot warrant full correctness of all content. With the help of other reference book and website, the motive to provide you easiest way to understand the coding, technology and other things.....

Beginner School