Thanks for that. I've used the ADO errors collection to return the messages as they all had a severity of 10 and were not returned by the @@ERROR functionality.

Cheers

It is not an error that I am trying to return, it is a message. I am using the stored procedure to backup a copy of a database to another...