Thanks for the replies!

One more question, though. when I join 2 tales using the 4 part name, doesn't the SQL server make the joins localy (e.g. - retrieve the data...

I can't call a stored procedure since the SQL is dynamically generated. Regarding the remote joins - is there an option to do all the joins remotely using the object...

Simon Hi. First of all thanks a lot for the quick reply.

I'm not sure I fully understood your answer. Can you please elaborate?

Do you mean I need to tag...

Hi,

I need quite the same ability to count the rows, but unfortunately, since my SQL is dynamically generated, can't rely on the fact that I will have a nice MyKey...