Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003
    Location
    South of France
    Posts
    11

    Unanswered: EXPORT of ALL DATA of a USER

    If anyone has a solution to export in a simple way all the rows of all the tables of a user in only one text file, for instance, please let me know how.

    I think that it is not possible quickly with DTS when the number of tables is a little bit high ...

    And I have not found how do it in a single command with BCP ...

    As a Junior Administrator, may be I'm wrong ...

    Thanks a lot ... and ... Happy New SQL SERVER Year !!!
    ALaupenie

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,799
    Provided Answers: 11
    Are you able to distinguish the rows specific to each user? Maybe a user_name column? If so, you can check on the QUERYOUT option for BCP.

Posting Permissions

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