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.
| Author |
Topic |
|
smorty44
Yak Posting Veteran
93 Posts |
 Posted - 2008-05-22 : 11:44:26
|
| is there a way to change the results tab settings before running a specific sp using osql? I'd like to set up a job to run a specific sp but need to change these options before it runs:tools, options, results tab to the following:Results to fileoutput format tab delimitedmax characters to 8192print column headers |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-05-22 : 11:50:17
|
| cant you use bcp utility for achieving the same? |
 |
|
|
smorty44
Yak Posting Veteran
93 Posts |
Posted - 2008-05-22 : 12:04:00
|
| this sp is using a temp table so I don't believe bcp will work |
|
|
|
|
|
|
change results tab setting using osql