OK, I now have a C# assembly that has a method called tableCompare that takes a stored Proc name and a table name as parameters and it then connects to the database and gets gets the structure of the table and calls the stored proc and captures the structure of the return ...

Current they just print out to the SQL message window, next is to start the comparison system ... I am stoked at this ... and the techniques are not that hard to do once you get used to it.