The download butkton at the bottom of the page.
It's an extended proc which you "install" on SQL.
The explination he gives makes it easy to use.
I have used it and not had any problems. It runs under SQL so no, it is not a virus or anything harmful.
If you want to dump results to file, this is the tool to use.
If you want to read a file from within a proc, BULK INSERT would be easier than BCP.
Have a look in BOL on "System Stored Procedures"
Cheers,
Crispin
Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!