Stored Procedure to Backup all Databases

This is the script I use to backup all my DB's this does fulls and dumps them locally to disk then spools them off to FTP. This stored procedure is designed to take 4 parameters @bksrv : This is the name or the IP address of the spooler or backup server to send to. @user : Login name for the FTP server @upass : Password for the FTP server @path : Local path files will be written to first. Thats it there is no return value. There are errors raised and logged in the script. Is there a cleaner better way to do this? I bet there is. I haven't seen one though. Enjoy