I just wanted to ask you a question about capturing SQL 2005 database
transactions and later replaying them on the same database in the test
environment. Is there a way to capture all transactions on a database to a
file and then posting these transactions to the same database on another
server. I understand that SQL profiler will let you capture transactions into
a trace file and will let me replay the transactions on a different server
but it won’t post the transactions on the database. Is there a Microsoft tool
or another third party tool that you would recommend to accomplish this?

Have you considered using triggers to append t-sql commands to a
file? Put a trigger on INSERT, UPDATE and DELETE on your tables and
have that trigger create a t-sql command using @variables. Remember
to use a cursor to create the command because there could be more than
one transaction.

A possible solution, may not be a good one if you want to do it on all
tables, however you can script out the triggers on one table once you
write the code and do a simple search and replace.

maybe not the best idea, but one that came to mind,

Erik