BCP Error

• mybid2003

  SSCertifiable

  Points: 6620

  More actions

  October 12, 2006 at 10:09 am

  #114731

  We have a SQL2005 STD Ed. on one of the servers with Win2k3. I want to export the users list with bcp. I am running the below command:

  bcp "db name"..sysusers out srvname_dbname_sysusers_c.dat -SSRVNAME -T -c

  I was getting the below error:

  "An error occurred while processing the command line."

  How do we bcp out from a database with space in the Db name?

  Same command is working on other databases without having the space in the dbname.

  Please Advise!!!

  .

• Rudyx - the Doctor

  SSC-Forever

  Points: 43695

  More actions

  October 13, 2006 at 10:35 am

  #665791

  Have you tried:

  bcp [db name]..sysusers out srvname_dbname_sysusers_c.dat -SSRVNAME -T -c

  RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."