spDelete_FundRaisers

    CREATE     PROCEDURE dbo.spDelete_FundRaisers
    (
        @PKID int,
        @CurrentUsersID    int
    )
    AS

    declare @IsCarePageManager bit

    if EXISTS(SELECT [ID] FROM dbo.FundraiserSolicitors WHERE FundraiserID = @PKID) or EXISTS(SELECT [ID] FROM dbo.FundraiserTeams WHERE FundraiserID = @PKID)
    BEGIN
        select @IsCarePageManager=[IsCarePageManager] from dbo.FundRaisers where [ID]=@PKID
        if @IsCarePageManager = 0
            RAISERROR('Unable to delete Fundraiser - It contains one or more participant records.',16,1)
        else
            RAISERROR('Unable to delete Personal Page Manager - It contains one or more page owners.',16,1)
        return 0
    END

    begin transaction
        DELETE FROM FundRaisers where ID = @PKID
    commit transaction