October 17, 2002 at 1:44 am
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
October 17, 2002 at 4:03 am
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)
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply