Encrypting Passwords in stored procedures manually scripted

warnerrawarnerra Posts: 5
edited October 5, 2006 10:52PM in SQL Backup Previous Versions

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.




  • peteypetey Posts: 2,358 New member
    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.
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
Sign In or Register to comment.