I would suggest running the SQL profiler over night. If your script inlcudes storedprocedure calls then add from the events tab Storedprocedure:

RPC:Starting and RPC:Completed

SP:Starting and SP:Completed

SP:StmtStarting and SP:StmtCompleted

you will also...