Thanks for your replies, this has now worked fine.

Thanks Amit.

I just want to check, does that only change the ownership on the database and none of the objects underneath and is it best practice to change to 'sa'?

Also,...