How *NOT* to display header column

Hi,

1. This is what SET NOCOUNT ON does:

-- SET NOCOUNT to ON and no longer display the count message.
SET NOCOUNT ON
GO
SELECT au_lname
FROM authors
GO

2. Now, is it possible and what is the statement to use if I don't want to display
the header column? au_lname. Thanks.From the Sql Bible:

SET NOCOUNT {ON | OFF}
SQL Server usually returns a message indicating how many rows were affected by any given statement. Issuing this command would stop this message.

HH

NeuralC|||Hi NeuralC

I already knew question 1 :-D . What is I'm looking for is question 2. Thanks.|||Hi,

Graphically, I got it for question 2 using Tools, Option ... from QA.

Still, statement-wise, what is it? Thanks.|||What client are you using...that's what renders the hender not SQL itself...unless you're talking about renaming the fields

hot to make sure a upgrade from sql 2005 standard to enterprise edition?

Randy,

I did run upgrade advisior to check the existed sql 2005 standard edition to upgrade to enterprise editon. I got the following error message:

SQL Server version: 09.00.1399 is not supported by this release of Upgrade Advisor

Is it means the upgrade advisor can only work on from 7.0, 2000 to 2005? If I need check from standard to enterjprise in 2005, what kind of tool I can use?

One of the SQL Server forums would be a better place to ask this question:

http://forums.microsoft.com/MSDN/default.aspx?ForumGroupID=19&SiteID=1

You'll have better luck finding an answer there.

-Tom