Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2004
    Posts
    5

    Unanswered: Unload Temporary table with BCP

    Hi all,

    I try to unload a temporary table, i'd to know if possible with bcp utility ?

  2. #2
    Join Date
    Aug 2004
    Posts
    38
    You can't use bcp on # temp tables as they are session specific and are unavailable to any other processes.

    You can bcp out of (and into) tempdb..temptables using standard bcp syntax, eg:

    bcp tempdb..mytab out mytab.bcp -Uuser .... etc

    HTH

Posting Permissions

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