Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

SE2008: Turning Off Column Headings in SSMS Results

0 views
Skip to first unread message

Gene Wirchenko

unread,
Aug 25, 2010, 6:06:37 PM8/25/10
to
Hello:

I am working through the documentation. Some of the programs
iterate to give results. In each case, they display the column
headings. How can I turn that off?

Sincerely,

Gene Wirchenko

Hugo Kornelis

unread,
Aug 25, 2010, 6:26:29 PM8/25/10
to

Hi Gene,

Assuming you use result to text mode, you can use Tools | Options |
Query Results | SQL Server | Results to Text - and then untick the
option "Include column headers in the result set".

--
Hugo Kornelis, SQL Server MVP
My SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis

0 new messages