March 17, 2004 at 3:24 am
Kind people,
I need to switch off column header and that annoying dash line when Dumping the output of a Store Procedure to a file on the network.
Is there a SET command which will do this for me ??
Many Thanks
Ahsen
March 17, 2004 at 4:32 am
If running from query analyzer, you can turn it off by click tools in menu, options, results, clean Print column headers(*) check box.
If running from osql, -h-1 is the answer.
March 17, 2004 at 4:34 am
THanks for your reply but No I just want to exclude them from my SP's output ...
I am running it as a sceduled job directly into a file ...
Any takers ?
March 17, 2004 at 6:33 am
The column headers are an intrinsic part of the recordset output and cannot be removed. Only the application that receives it can choose not to display them. wz700 is correct in his statement on how to stop them from being displayed in QA and OSQL (the applications using the recordset(s)).
What ever you are using as 'a sceduled job directly into a file ...' will have to choose not output the headers.
What is the job in question and what does it do?
Far away is close at hand in the images of elsewhere.
Anon.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply