USP_UIWIDGETCATALOG_REMOVEFROMALLCATEGORIES

create procedure dbo.USP_UIWIDGETCATALOG_REMOVEFROMALLCATEGORIES(
    @UIWIDGETCATALOGID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null
)
as
begin
    if @CHANGEAGENTID is null  
        exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;

    declare @contextCache varbinary(128);

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

    /* set CONTEXT_INFO to @CHANGEAGENTID */
    set CONTEXT_INFO @CHANGEAGENTID;

    delete from dbo.UIWIDGETCATEGORYLINK where UIWIDGETCATALOGID = @UIWIDGETCATALOGID;

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

end