Results 1 to 5 of 5

Thread: bcp Execution

  1. #1
    Join Date
    Jul 2004
    Location
    Mars
    Posts
    137

    Lightbulb Unanswered: 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
    Sudar

  2. #2
    Join Date
    Jul 2004
    Location
    Inverurie
    Posts
    628
    i would have thought it would be best to run it on the server myself, but it really depends what you are trying to do.

  3. #3
    Join Date
    Jul 2004
    Location
    Mars
    Posts
    137
    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

  4. #4
    Join Date
    Feb 2004
    Posts
    492
    Did you try -s ?

  5. #5
    Join Date
    Jul 2004
    Location
    Mars
    Posts
    137

    Thumbs up Thnks

    Thnks kaiowas it's working correctly......

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •