Thanks. Our SSIS package does check to see that the file exists. We check in SQL first because we don't even want to run SSIS if it does...

We've recently started using fitnesse with DbFit for automated acceptance testing and TDD on the database side. It allows you to role back transactions when complete.

http://www.fitnesse.info/dbfit:reference

Thanks. I think that is probably the way we'll go.

The table names are fully qualified. The issues I'm facing is the function's have bad code (cursors, more nested function calls, etc...) that make them both poorly performing and...

Have you considered using Service Broker to replay transactions in the other databases? Or, you could set up linked servers between each of the databases, and if your using...

It looks like this may be down to hardware. We moved it to another test environment with a little better hardware and more horsepower and it improved drastically. ...