How can we help you today? How can we help you today?

Encrypting Passwords in stored procedures manually scripted

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
warnerra
0

Comments

1 comment

Sort by
  • 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.
    petey
    0

Add comment

Please sign in to leave a comment.