>Hi Don ----
>
>Good point on the "rights". But I just ran =SQLEXEC(nCH,"sp_helpindex client") against a SQL 6.5 database with no problem.
>
>>If it is a user defined stored procedure, make sure that the procedure has been granted to all users, if not, it won't be visible to anyone... And with respect to "EXEC sp_name", it was required for me just for purpose of using "sp_helpindexes" which is a system stored procedure.

yeah, sp_helpindexes is system controlled...
for Mark, it appears he created his own and didn't give permissions for anyone logged in, to use it.