sp_foreign_keys

6 Aug 2006 8:53 AM

Patrick

sp_foreign_keys_rowset

Does anyone know how to call this from csharp?
I've profiled that the correct sql is going to the server (and it runs in
QA) but ADO will not return a DataReader when I know there are results.

Any help is MUCH appreciated.

Thanks!
Patrick

6 Aug 2006 7:32 PM

William (Bill) Vaughn

Let's see your code. I expect that you might be receiving more than one
resultset so you might have to bump the DataReader to the next.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________

Show quote

"Patrick" <cpar***@home.com> wrote in message
news:%23gwHJXTuGHA.4968@TK2MSFTNGP03.phx.gbl...
> sp_foreign_keys_rowset
>
> Does anyone know how to call this from csharp?
> I've profiled that the correct sql is going to the server (and it runs in
> QA) but ADO will not return a DataReader when I know there are results.
>
> Any help is MUCH appreciated.
>
> Thanks!
> Patrick
>