USP_MEMBERSHIPPROGRAM_MICROSITEEMAILTEMPLATE_DELETEBYID_WITHCHANGEAGENTID

/*
Generated by Blackbaud AppFx Platform
Date:  11/11/2014 4:03:06 PM
Assembly Version:  Blackbaud.AppFx.Platform.SqlClr, Version=4.0.2.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE PROCEDURE dbo.USP_MEMBERSHIPPROGRAM_MICROSITEEMAILTEMPLATE_DELETEBYID_WITHCHANGEAGENTID(@ID UNIQUEIDENTIFIER,@CHANGEAGENTID UNIQUEIDENTIFIER=NULL)
AS

    /*    
    Sets Context Info to the CHANGEAGENTID
    Deletes a row in the MEMBERSHIPPROGRAM_MICROSITEEMAILTEMPLATE table with the given ID
    Resets Context info to the previous value

    The Context Info will be used by delete triggers to log the AUDITCHANGEAGENTID 
    as the supplied @CHANGEAGENTID rather than the default change agent id.
    */

    set nocount on;

    declare @e int;
    declare @contextCache varbinary(128);

    /* cache current context information */
    set @contextCache = CONTEXT_INFO();

    /* set CONTEXT_INFO to @CHANGEAGENTID */
    if not @CHANGEAGENTID is null
        set CONTEXT_INFO @CHANGEAGENTID

    delete from dbo.MEMBERSHIPPROGRAM_MICROSITEEMAILTEMPLATE where ID=@ID;

    /* reset CONTEXT_INFO to previous value */
    if not @contextCache is null
        set CONTEXT_INFO @contextCache

    select @e=@@error;

    if @e<>0 return -456; --always return non-zero sp result if an error occurs


    return 0;