Encrypting Passwords in stored procedures manually scripted

warnerra

Hello,

As a security measure, is it possible to cause the password used for encryption to be encrypted within a stored procedure that is created outside the wizard?

I realize this happens for jobs created via the wizard, but I must script the jobs outside the wizard.

Thanks,

Rick

petey

You would need to use the Backup Wizard to generate the encrypted values, which you can find on Step 6 of the wizard, on the 'Script' tab.