I know this is an old post, but has this changed? I have not read anything on it. In most languages you have an Exception and an inner Exception. It would be very handle to have the inner exception in this case as I can make my script more fail-safe. Instead, I am not thinking about programming a service in .NET to handle what SQL scripting is not able to.

Any thought or new concepts?