USP_MATCHFINDER_GETSITEID

Retrieves and decrypts the site ID used to authenticate with the MatchFinder Online service.

Parameters

Parameter	Parameter Type	Mode	Description
@SITEID	nvarchar(100)	INOUT
@KEYALREADYOPEN	bit	IN

Definition

Copy



            create procedure dbo.USP_MATCHFINDER_GETSITEID
            (
                @SITEID nvarchar(100) = null output,
                @KEYALREADYOPEN bit = 0
            )
            as
            set nocount on;

            begin try
                exec dbo.USP_GET_KEY_ACCESS;

                select 
                    @SITEID = coalesce(convert(nvarchar(100), DecryptByKey(SITEID)), '')
                from dbo.MATCHFINDERCONFIGURATION;

                close symmetric key sym_BBInfinity;
            end try
            begin catch
                exec dbo.USP_RAISE_ERROR;
                close symmetric key sym_BBInfinity;
                return 1;
            end catch

            return 0;