USP_BBWORKFLOW_SERVICE_CREATE_AUX_SERVICE

create procedure dbo.USP_BBWORKFLOW_SERVICE_CREATE_AUX_SERVICE

    @AUXILIARYWORKFLOWSERVICENAME nvarchar(126)

with execute as owner

/*
Creates the SQL Server Service Broker objects for an auxiliary workflow service
*/

as


    if not exists (SELECT service_id FROM sys.services WHERE name = @AUXILIARYWORKFLOWSERVICENAME)
        begin

            exec dbo.USP_BBWORKFLOW_ENSURE_AUXSERVICE_EXISTS @AUXILIARYWORKFLOWSERVICENAME;

        end


    return 0;