You can't pass around cursors, so your best options are ADO or XML.
>ok,
>
>Another stupid question. I think I would run into some limitations passing generated XML around as string parameters.
>
>For example, if a query produces result sets containing 500 records or something.
>
>Any experience with that?
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer