USP_ENCRYPTEDFILE_GET

Returns information about an encrypted file.

Parameters

Parameter	Parameter Type	Mode	Description
@FILEPATH	nvarchar(260)	IN
@AESINITIALIZATIONVECTOR	varbinary	INOUT

Definition

Copy



            create procedure dbo.USP_ENCRYPTEDFILE_GET
            (
                @FILEPATH as nvarchar(260),
                @AESINITIALIZATIONVECTOR varbinary(16) output
            )
            as
                set nocount on

                set @FILEPATH = rtrim(ltrim(lower(@FILEPATH)))

                exec dbo.USP_GET_KEY_ACCESS
                begin try
                    select
                        @AESINITIALIZATIONVECTOR = convert(varbinary(16), DecryptByKey(AESINITIALIZATIONVECTOR))
                    from dbo.ENCRYPTEDFILE
                    where FILEPATH = @FILEPATH

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