Hi Don ---
BINGO....and it might be suggested (I'll CC him with this reply) that he try:
=SQLEXEC(nConnection,"sp_helpindex sometablename") as a test.
>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.
------------------------------------------------
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