USP_BBNC_DELETESURVEY

            CREATE procedure dbo.USP_BBNC_DELETESURVEY
            (
                @BBNCSURVEYID int,
                @CHANGEAGENTID uniqueidentifier
            )
            as
            set nocount on;

            begin try
                if @CHANGEAGENTID is null
                    exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;

                declare @CONTEXTCACHE varbinary(128);
                set @CONTEXTCACHE = CONTEXT_INFO();

                if not @CHANGEAGENTID is null
                    set CONTEXT_INFO @CHANGEAGENTID;

                delete from dbo.SURVEY where BBNCSURVEYID = @BBNCSURVEYID;

                if not @CONTEXTCACHE is null
                    set CONTEXT_INFO @CONTEXTCACHE;

            end try
            begin catch
                exec dbo.USP_RAISE_ERROR;
                return 1;
            end catch

            return 0;