USP_DATAFORMTEMPLATE_VIEW_TENANT

CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_TENANT
(
  @DATALOADED bit = 0 output,
  @TENANTID uniqueidentifier = null output,
  @SKYACCESSKEY nvarchar(36) = null output
)
as
  set nocount on;

  set @DATALOADED = 0;

  select top (1)
    @TENANTID = AUTHSERVICETENANTID
  from dbo.INSTALLATIONINFO;

  exec dbo.USP_GET_KEY_ACCESS;

  begin try
    select top (1)
      @SKYACCESSKEY = convert(nvarchar(36), DecryptByKey(SKYACCESSKEY))
    from dbo.SKYACCESS;

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

  if @TENANTID is not null
  begin
    set @DATALOADED = 1;
  end

  return 0;