USP_EXCHANGESERVER_GETAUTHENTICATIONINFO

            create procedure dbo.USP_EXCHANGESERVER_GETAUTHENTICATIONINFO
            (
                @EXCHANGESERVERID uniqueidentifier = null
            )
            as
                set nocount on;

                -- Open the symmetric key for encryption

                exec dbo.USP_GET_KEY_ACCESS;

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

                -- Make sure we close the symmetric key

                close symmetric key sym_BBInfinity;