Over the past couple of years, we’ve had *tons* of requests for the DDM (the Dual Database Monitor – which is a little utility for testing and checking out a mirroring partnership…) and finally, we’ve (ha, pretty much only Paul :)) made it more flexible (it was hard-coded with specific insert procs). He’s created an ini to allow implicit or explicit client redirection (to see the benefits of Transparent Client Redirect), written a help file, and he’ll keep you posted with updates/bug fixes…
If you’re interested, Paul’s blogged about it here: https://www.sqlskills.com/blogs/paul/2008/01/13/DualDatabaseMonitorNowAvailableToOrder.aspx
Have fun and HAPPY NEW YEAR!
kt