Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 osql maximum -w column_width

Author  Topic 

Kristen
Test

22859 Posts

Posted - 2005-12-08 : 04:50:00
How do I stop OSQL wrapping the output?

Is there some "maximum" I can set with the -w switch?

Thanks

Kristen

jhocutt
Constraint Violating Yak Guru

385 Posts

Posted - 2005-12-08 : 08:52:44
osql -w
Column width [-w] value must be greater than 8 and less than 65536.
But seems like I remember running into trouble with lines when hey got close to the max.
I never could find a way to increase it beyond that.

"God does not play dice" -- Albert Einstein
"Not only does God play dice, but he sometimes throws them where they cannot be seen."
-- Stephen Hawking
Go to Top of Page

jhocutt
Constraint Violating Yak Guru

385 Posts

Posted - 2005-12-08 : 09:07:56
Try ISQL instead.
isql -w
Column width [-w] value must be greater than 9 and less than 2147483648.


"God does not play dice" -- Albert Einstein
"Not only does God play dice, but he sometimes throws them where they cannot be seen."
-- Stephen Hawking
Go to Top of Page

Kristen
Test

22859 Posts

Posted - 2005-12-08 : 13:00:35
Thanks James, I'll give it a go. I think that isql is deprecated (and dropped from 2k5), but there again osql is itself deprecated in 2k5 ...)

Kristen
Go to Top of Page
   

- Advertisement -