I am getting a around 200/500 lines of query results that is DDLs etc returned from my dot net query. It works on SQL assistant okay. When I send it using the below query I only get the first DDL and not other DDLs.
Any idea, if this is a limitation or any setting that I need to take a look?
Here is my code:
The results are probably returned as separate result sets so you will need to call NextResult() and loop through all future result sets as well as the first one.
(apparently some code is omitted/extra here as you appear to be referencing both a DataSet AND a DataReader ... which are alternatives.)
Mike, Many thanks!
That worked lke a charm....!!!!
I had to use the nextResult within my loop and concatinate it with vbCrLf something like this: