isql output

• Nico Verbaenen

  SSChasing Mays

  Points: 649

  More actions

  October 17, 2002 at 1:44 am

  #79238

  Hi,

  I use Isql with input and output files. The input files are selects and DBCC statements.

  In my output files I get the resultset of these statements.

  When I use de DBCC statements SHOWCONTIG you always get the message:"DBCC execution completed. If DBCC printed error messages, contact your system administrator."

  Can I specify that I only want the resultset in my output file and not the messages that SQL gives?

  Nico

• Antares686

  SSC Guru

  Points: 125444

  More actions

  October 17, 2002 at 4:03 am

  #438755

  One way to get the screen message from ISQL is to > to a text file.

  Ex.

  isql -S local -E -Q "DBCC SHOWCONTIG..." > c:\SHOWCONTIGFORDB.txt

  on in the case of SHOWCONTIG use the WITH TABLERESULTS option to output to a table format that the output file will work with.

  "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)