bcp and queryout problem

• sseetha

  SSC Veteran

  Points: 217

  More actions

  August 26, 2010 at 2:13 am

  #141700

  hi all,

  im getting SQLState = 28000, NativeError = 18456 error wen i execute the query mentioned below.

  exec master.dbo.xp_cmdshell 'bcp "SELECT * FROM customer for XML auto, ELEMENTS XSINIL" queryout e:\sample.txt -c -T -U"sa" -P"e2s"'

  exec master.dbo.xp_cmdshell 'bcp "SELECT * FROM customer for XML auto, ELEMENTS XSINIL" queryout e:\sample.txt -c -T'

  im getting this problem even after changing the configuration

  config settings

  USE master

  GO

  EXEC sp_configure 'show advanced options', 1

  GO

  RECONFIGURE WITH OVERRIDE

  GO

  EXEC sp_configure 'xp_cmdshell', 1

  GO

  RECONFIGURE WITH OVERRIDE

  GO

  EXEC sp_configure 'show advanced options', 0

  GO

  🙁

  pls help me

  thanks in advance..

• RamG

  Right there with Babe

  Points: 767

  More actions

  March 2, 2011 at 6:34 am

  #1293456

  Hi i think u missed the dbname and owner name please try the following query.

  exec master.dbo.xp_cmdshell 'bcp "SELECT * FROM [dbname].dbo.customer for XML auto, ELEMENTS XSINIL" queryout e:\sample.txt -c -T -U"sa" -P"e2s"'