Try taking the full database backup and then see if this works.

backup log <dbname> with no_log

What is the issue here ?

Why do you want to have the database in single user mode for changing database application.

If you are modifying certain SP's, I don't think you...