I had 2008 on my system and created a database for a customer. I backed it up and restored it to their R2 system. I made a few changes on...

I tried it and was very hopeful but ended up with the same error message. I created the 'superman' super-user exactly as you demonstrated. I modified my procedure with the...

Thanks for this, I should get a chance to try it on Monday or possibly over the weekend.

Gav

Usually, because sp_OACreate can only be run from a sysadmin account, we have to run a script like the following to allow a user to execute it. In this case...