Vidhya, thanks a lot for the script. Please explain when uncommitted transactions could be in the log file and been rolled back.

Steve, thanks for the tip on the log files...

We did not move the ldf files, because we had 1 500 hundred databases to move. This from a very slow server. The detach process would have taken a very...