Unhandled Exception

Jul 19, 2011 at 9:52 PM

Firstly, thanks for making this tool available. I'm getting unhandled exceptions due to objects no longer existing in the database. Obviously the stored procs in question is no longer valid and needs to be cleaned-up. I'm afraid there may be quite a few of these situations with this particular database which means many iterations of running this and chasing the errors. However it would be nice to be able to specify "continue on error" and log the error into an exception file. This would at least allow the user to get all valid objects scripted and find those that are problem children. Thanks again!

Coordinator
Jul 20, 2011 at 1:23 AM

Sounds like the same problem from http://exportsqlscript.codeplex.com/discussions/263876

I'll look to find some time & handle this.

Jul 20, 2011 at 7:08 PM

Thanks. I found all the stored procs and a couple views that reverenced this one deleted table and made it through the rest of the stored procs. Unfortunately I ran into another exception and I'm having a difficult time moving past it. I'll start a new discussion on it.