September 25, 2002 at 11:46 pm
Hello,
When I Use the DBCC command SHOWCONTIG WITH TABLERESULTS I get the result in a recordset like manor. When I execute this command from osql or isql I get the output as if the WITH TABLERESULTS option wasn't specified. Does anyone have an idee how I can solve this problem?
Greetz,
Nico
September 26, 2002 at 4:34 am
How are you running as both OSQL and ISQL qork fine for me. They just have a horrible effect on the wrap of the data making it harder to read without tweaking.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
September 26, 2002 at 5:03 am
My other statements all work fine with the isql command. It's just that with this statement he seems to let the TableResults option out of the statement...
September 26, 2002 at 10:32 am
What do you mean the output is the same as if you don't run WITH TABLERESULTS?
I suspect that this is due to the fact the a recordset is not returned by isql, but rather text.
Steve Jones
September 26, 2002 at 10:21 pm
If you run the script in http://www.sqlservercentral.com/scripts/scriptdetails.asp?scriptid=473
you will se that it runs dbcc showcontig for all indexes and it also writes a log to a file with osql.
Rate the script, please.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply