---SQL Server 2008---
IF OBJECT_ID(N'[dbo].[nome_stored]', N'P') IS NOT NULL
DROP PROCEDURE [dbo].[nome_stored]
GO
---SQL Server 2008 R2---
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID('[dbo].[nome_stored]') AND type in ('P'))
DROP PROCEDURE [dbo].[nome_stored]
GO