Please does anyone know what will work best to test a sql server data warehouse. What I really need most is a software to make user acceptance tests user friendly and simple. I have test sql statements/procs for data load and cognos reports outputs which I need to automate rather then use query analyzer.
I appreciate any hints.