Stored Procedure: CommandText does not return a result set

[pam]

I am trying to run the SQL Server stored procedure sp_helpindex.
Problem is, not every table has an index, so sometimes the SP returns
nothing. When this happens, I get the above error message. I've
googled this error and tried everything mentioned. If I use a
TADOStoredProc and ExecProc, the data doesn't come back. If I use
TADOStoredProc and Open, I get the error. If I use TADODataset, I get
the error. I've tried adding a call to SET NOCOUNT ON before the
stored procedure but that didn't help at all.

So for now, I'm wrapping the call in a try..except and just eating the
error. Not the best solution.

Any other ideas?

(I don't know if this has any relevance, but I've got another
TADODataset that runs a select against a SQL Server function and it
doesn't error out like this.)

I'm using SQL Server 2000 and Delphi 5 build 618 update pack 1 and (I
think) both ADO updates.

Pam