Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.
MODE CON COLS=132
Then you can use the -w parameter on OSQL to set the width. However, this only applies to each session, and so if you run xp_cmdshell twice, once to set the width, once to do the export, you will lose the width setting when the export runs. Therefore, create a batch file and run that, with MODE... as the first line, and OSQL ... as the second.
A better way to do the export is to use BCP, which is happy to do wide rows. Try
xp_cmdshell('BCP pubs.dbo.authors out C:\test.txt -w -T')
It will give you a tab-separated row, with CRLF at the end of each row, just right for import into Excel etc.