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