BCP Out each result of a query in a saperate file

hi,

i am trying to BCP out the result of a query to a seperate file. i am trying to create a seperate file for each record. could somebody please help me out?

Pankaj

Do you really mean a seperate file for each row?
Or a separate file for each table?

If it's for each row, then how many rows are there?
..and why?

/Kenneth

|||

yes,

seperate file for each row. just trying to send file as per required by customer. by the way i am trying with CURSORS.

Pankaj

|||

Sorry for the late answer, it's busy times ;o)

It seems a very odd request from your customer...
In a query, how many rows are you expecting to do this on?

/Kenneth

bcp Execution

Hai..

I have two systems. SQL server 2000 is installed in one system (SERVER ) and the client tools are installed in a seperate system (Client)
My question is from which system should i have to execute the bcp command line utility, from the server or from the client. ?

Thanks in advance...

with regards
Sudari would have thought it would be best to run it on the server myself, but it really depends what you are trying to do.|||Hai..

thnks for your reply...

Actually i want to know whether it is possible to execute bcp from client or not and if yes then how.. ?

bcoz there is no argument in bcp to identify the server name..

thnks in advance

With regards
Sudar|||Did you try -s ?|||Thnks kaiowas it's working correctly.....