:r dumpdb
go
drop procedure sp__get_tmp_error
go
drop procedure sp__grep

:r dumpdb
go
drop procedure sp__get_tmp_error
go
drop procedure sp__grep

-- =============================================
-- Create basic stored procedure template
-- =============================================
IF EXISTS (

-- =============================================
-- Create basic stored procedure template
-- =============================================
IF EXISTS (

-- Volunteer Stored Procedures
-- DR -- 1/28/2005
CREATE PROCEDURE V_CreateCommitment

DROP SEQUENCE document_ids;
DROP SEQUENCE phone_ids;
DROP PROCEDURE create_person;
DROP PROCEDURE delete_person;
DROP PROCEDURE add_phone;

exec sp__helpdepends %s, 'stored procedure'

DROP SEQUENCE document_ids;
DROP SEQUENCE phone_ids;
DROP PROCEDURE create_person;
DROP PROCEDURE delete_person;
DROP PROCEDURE add_phone;

exec sp__helpdepends %s, 'stored procedure'

DROP SEQUENCE document_ids;
DROP SEQUENCE phone_ids;
DROP PROCEDURE create_person;
DROP PROCEDURE delete_person;
DROP PROCEDURE add_phone;

DROP SEQUENCE document_ids;
DROP SEQUENCE phone_ids;
DROP PROCEDURE create_person;
DROP PROCEDURE delete_person;
DROP PROCEDURE add_phone;

DROP PROCEDURE getSessionNewPrimaryKey;
DROP PROCEDURE getHandleNewPrimaryKey;
DROP PROCEDURE getHandleActionNewPrimaryKey;

IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'Stored_Procedure_Name')
     BEGIN
          DROP  Procedure  Stored_Procedure_Name

IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'Stored_Procedure_Name')
     BEGIN
          DROP  Procedure  Stored_Procedure_Name

   leftarg = path,
   rightarg = path,
   procedure = path_inter,
   commutator = ## 
);

   leftarg = path,
   rightarg = path,
   procedure = path_inter,
   commutator = ## 
);

-- ===============================================
-- Create stored procedure with OUTPUT parameters
-- ===============================================
IF EXISTS (

-- ===============================================
-- Create stored procedure with OUTPUT parameters
-- ===============================================
IF EXISTS (

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Proc1]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[Proc1]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Proc1]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[Proc1]
GO

-- =======================================================
-- Create stored procedure with CURSOR OUTPUT parameters 
-- =======================================================
-- drop stored procedure if it already exists

-- =======================================================
-- Create stored procedure with CURSOR OUTPUT parameters 
-- =======================================================
-- drop stored procedure if it already exists

PROMPT Compiling PACKAGE TVSCRIPT
ALTER PACKAGE TVSCRIPT COMPILE;
PROMPT Compiling PROCEDURE TV$ANA_CK_CONSTRAINTS
ALTER PROCEDURE TV$ANA_CK_CONSTRAINTS COMPILE;
PROMPT Compiling PROCEDURE TV$ANA_CLUSTERS

drop procedure create_person
drop procedure set_person_name
drop procedure delete_phone

/* Install script, Newsletter by Manu 06/10/2003 */
IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID(N'[rb_AddToBlackList]') AND OBJECTPROPERTY(id, N'IsProcedure') = 1)
DROP PROCEDURE [rb_AddToBlackList]
GO