USP_EMAILSERVICESSETTINGS_LOAD

create procedure dbo.USP_EMAILSERVICESSETTINGS_LOAD
as
begin
  /*
   BlackbaudServiceHost = 9
   BlackbaudServiceUser = 10
   BlackbaudServicePassword = 11
   BlackbaudServiceUseSecureServices = 12
*/

exec dbo.USP_GET_KEY_ACCESS
begin try    
  select [ID]
        ,[NAME]
        ,[VALUE]
        ,[CREATEDATE]
        ,[UPDATEDATE]
    from [dbo].[SETTING]
    where ID in (9, 12)

  union

  select [ID]
        ,[NAME]
        ,DECRYPTBYKEY([Value]) 'Value'
        ,[CREATEDATE]
        ,[UPDATEDATE]
    from [dbo].[SETTING]
    where ID in (10, 11)

  close symmetric key sym_BBInfinity
end try
begin catch
  close symmetric key sym_BBInfinity
end catch


end