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.
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. ...