USP_AUTHENTICATE_PLUGINSERVICE_TOKEN

Checks whether the specified token has been registered in the database as valid.

Parameters

Parameter	Parameter Type	Mode	Description
@TOKEN	uniqueidentifier	IN
@AUTHENTICATED	bit	INOUT

Definition

Copy



CREATE procedure dbo.USP_AUTHENTICATE_PLUGINSERVICE_TOKEN
(
    @TOKEN uniqueidentifier,
    @AUTHENTICATED bit = 0 output
)
as
begin
    declare @temp TABLE(BinaryData image, TextData ntext);
    insert into @temp exec [dbo].[spTempDataFetch] @TOKEN;
    if exists(select null from @temp)
        set @AUTHENTICATED = 1;
    else
        set @AUTHENTICATED = 0;
    delete from dbo.TempData where ID = @TOKEN;
end