USP_IMPORTPROCESS_GETNETWORKDIRECTORYINFO

create procedure dbo.USP_IMPORTPROCESS_GETNETWORKDIRECTORYINFO
as
begin
    set nocount on;

    -- Open the symmetric key for decryption

    exec dbo.USP_GET_KEY_ACCESS;

    select ID, URLORPATH, IMPERSONATE, USERNAME, convert(nvarchar(200), DecryptByKey(PASSWORD)) PASSWORD from dbo.IMPORTSOURCE where IMPORTSOURCETYPECODE = 1 order by DATEADDED desc;

    close symmetric key sym_BBInfinity;    
end