I have a stored procedure that I execute on different databases to present results. What's the easiest way to compare these results ?
asked Jun 23, 2012 at 06:15 AM in Default
Funnily enough, I had the same requirement recently. I blogged my approach here: http://thelonedba.wordpress.com/2012/06/21/warning-wordbreaker-filter-or-protocol-handler-used-by-catalog-foo-does-not-exist/
The gist of the process is:
It's all relatively straightforward, just a bit long-winded. I'm sure I could have written the code better, for example!
This technique only works if there is one recordset output by your SP.
Things you'll need to know about:
Hope this helps.: http://msdn.microsoft.com/en-us/library/ms189837.aspx