Tim S:

Yes, I did try it. Thanks!

It will fail if the proc being executed creates a temp table.  If it's a straight SQL statement, it seems to work; but if...

Thanks to all that replied, but I don't think I made my issue clear enough.

When I process a SQL Select, it could be simply an EXEC <stored proc name> or...

Sergey:

Yes, that would work, but I won't have the ability to touch the SQL.  I am building a wrapper around ADO that instead of running the query will schedule it...

Sergey:

Yes, that would work, but I won't have the ability to touch the SQL.  I am building a wrapper around ADO that instead of running the query will schedule it...