Thanks for your quick reply.
First I want apologize as I'm a newbie around these tools.
I like the idea working with the SQL2000 tools installed on the PC workstation.
I've looked at the BCP utility but it looks like I can basically only copy tables and not run SQL query into it. Actually if I can run a stored procedure that is sitting on the SQL2000 server, that would be the best. If not I will execute the SQL query everytime from the PC workstation.
Also...what is BOL ?
Many thanks in advance,
Rob