USP_OLAPDATASOURCE_VALIDATEQUEUEDELETE

            CREATE procedure dbo.USP_OLAPDATASOURCE_VALIDATEQUEUEDELETE
            (
                @ID uniqueidentifier
            )
            with execute as caller
            as
                if @ID is not null
                begin

                    if exists (select 1 from dbo.[OLAPDATASOURCE] where [BEFORE_ETL_QUEUEPROCESSID] = @ID or [AFTER_ETL_QUEUEPROCESSID] = @ID)
                        raiserror('The queue cannot be deleted because it is being used by an ETL process.',13,1);

                end
                return 0;