USP_EXCHANGEINTEGRATION_GETAUTHENTICATIONINFO

            CREATE procedure dbo.USP_EXCHANGEINTEGRATION_GETAUTHENTICATIONINFO
            as
                set nocount on;

                -- Open the symmetric key for encryption

                exec dbo.USP_GET_KEY_ACCESS;

                select
                    EXCHANGEINTEGRATION.USERNAME,
                    coalesce(convert(nvarchar(100), DecryptByKey(EXCHANGEINTEGRATION.PASSWORD)),'') as PASSWORD,
                    EXCHANGEINTEGRATION.DOMAIN,
                    EXCHANGEINTEGRATION.URL,
                    EXCHANGEINTEGRATION.USEIMPERSONATION,
                    case when EXCHANGEINTEGRATION.USEIMPERSONATION = 0 then
                        (select APPUSER.ID from dbo.APPUSER where APPUSER.USERNAME = EXCHANGEINTEGRATION.DOMAIN + '\' + EXCHANGEINTEGRATION.USERNAME)
                    else
                        null
                    end as APPUSERID,
                    EXCHANGEINTEGRATION.SUBSCRIPTIONPAUSELENGTH
                from
                    dbo.EXCHANGEINTEGRATION;

                -- Make sure we close the symmetric key

                close symmetric key sym_BBInfinity;