how to check the procedure is already exists in database

[developerit]

hi iam using asp.net with c# i want to check through coding is procedure already exists in database or not can you give example which helps me

[Blue_Boy]

IF EXISTS(SELECT name FROM sysobjects WHERE name = 'yourspname' AND type = 'P')
DROP PROCEDURE yourspname
CREATE PROCUEDURE
.
.
.

---

I Love T-SQL "Don't torture yourself,let the life to do it for you." If my post helps you kindly save my time by voting my post. www.aktualiteti.com