TechQA.

PGP Encryption Hanging From SQL

111 views Asked by JohnJSmith At 14 October 2024 at 19:36

I'm trying to use the code below to encrypt a file through sql, however the command hangs. It does create a temporary file. The key is RSA.

declare @cmd varchar(1000),
        @FileName varchar(1000),
        @keyname varchar(1000),
        @trust varchar(50)

SET @cmd ='pgp -e \Alpha\c$\temp\BATCH.csv [email protected]'
EXEC master..xp_cmdshell @cmd

Any idea what could be causing it to freeze ?

There are 0 answers