>One of the "gotchas" with bringing down multiple tables with one SP, is that the table names are *always* table, Table1, Table2, etc. and I haven't found any way around that. So, you have to have your DataSet tables named appropriately. But, since we use typed DataSets, it's no big deal ... we can name our tables however we want to in the typed DataSet and thus have meaningful names to access our tables with.
>

In your scenarios, could you make separate fill calls for each table in the dataset, always passing the same dataset to each subsequent fill call? Or, have you found it to be more efficient to make one call?

Also, do you make use of the client-side features such as enforcing constraints,relations, RI, etc?