bcp syntax error

• Faye Fouladi

  SSCrazy

  Points: 2770

  More actions

  February 2, 2009 at 12:24 pm

  #127708

  The following code

  EXEC master..xp_cmdshell 'bcp "SELECT * FROM dbo.authors" queryout "C:\bcptest.txt" -T -c -t,'

  gives me the error:

  Error = [Microsoft][SQL Native Client][SQL Server]Invalid object name 'dbo.authors'.

  What is wrong with this code?

  Thanks for helping.

• Lynn Pettis

  SSC Guru

  Points: 442467

  More actions

  February 2, 2009 at 12:29 pm

  #936652

  Try adding the database name to the query: pubs.dbo.authors (or whatever your db name is).

• Faye Fouladi

  SSCrazy

  Points: 2770

  More actions

  February 2, 2009 at 12:35 pm

  #936661

  Thanks Lynn, It worked.

  Merci Beaucoup