stored procedure results into text file

• Siddu-916480

  SSC Journeyman

  Points: 86

  More actions

  December 22, 2008 at 9:15 pm

  #127629

  How to export the results of the system stored procedure into text file.

  I tried

  bcp "xp_readerrorlog 1" out "c:\file.txt" -T -c

  but it dint work... please help me out...

  thanks,

  sid

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736222

  More actions

  December 22, 2008 at 9:17 pm

  #916542

  Use sqlcmd instead. It can send all output to a file.

• Siddu-916480

  SSC Journeyman

  Points: 86

  More actions

  December 22, 2008 at 9:24 pm

  #916548

  could you please help me with the code??? I dont know how sqlcmd works...

  thanks,

  sid

• Kishore.P

  SSCrazy Eights

  Points: 8147

  More actions

  December 23, 2008 at 2:55 am

  #916632

  siddalingaswamyd (12/22/2008)

  ---

  could you please help me with the code??? I dont know how sqlcmd works...

  thanks,

  sid

  try like:

  sqlcmd -E -Q "exec xp_readerrorlog 1" -o "C:\out.txt"

  it works fine.

• Grant Fritchey

  SSC Guru

  Points: 398882

  More actions

  December 23, 2008 at 6:13 am

  #916729

  For the full list of sqlcmd settings and commands, please consult the Books Online.

  "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
  - Theodore Roosevelt

  Author of:
  SQL Server Execution Plans
  SQL Server Query Performance Tuning