USP_QUERYVIEW_DELETEADDEDBYRELATIONSHIPS

CREATE procedure dbo.USP_QUERYVIEW_DELETEADDEDBYRELATIONSHIPS
(
    @ADDEDBYQUERYVIEWID uniqueidentifier, 
    @CHANGEAGENTID uniqueidentifier=null
)
with execute as caller
as
    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.QUERYVIEWRELATIONSHIP where ADDEDBYQUERYVIEWID = @ADDEDBYQUERYVIEWID;

    /* 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;