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.
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05