In SQL 2005 Server Management Studio, when you type T-SQL commands into a
SQL query box, keywords are colored blue, comments are green, etc. (by
default).

Why is the word SERVICE colored blue like a T-SQL keyword?

Thanks.

David Walker

[Service] is an object that you can create, drop, and use. Therefore it is
also a T-SQL keyword.

--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous

You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf

"Arnie Rowland" 1568.com> wrote in
news:OvVsbCT$GHA.3260@TK2MSFTNGP02.phx.gbl:

Where is this documented? Why doesn't the word SERVICE have an index entry
in BOL 2005?

Why isn't SERVICE in the list of T-SQL reserved words in BOL 2005? (I
guess it's not a reserved word even though it gets colored blue.)

And why, if anyone knows, does sending feedback on BOL 2005 fail with:

microsoft.com>:
205.248.106.30 does not like recipient.
Remote host said: 550 5.1.1 User unknown

???

Thanks.

David

You're not getting anything returned in the index on the word 'service'? In
the most recent update to BOL, the index returns the following choices when
SERVICE is the keyword.
service See services [Analysis Services]
service See services [Integration Services]
service See services [Notification Services]
service See services [Reporting Services]
service See services [Service Broker]
service See services [SQL Server]

Or where you expecting to see something like this in the index?

SERVICE
ALTER
CREATE
DROP

If so, we could consider doing that in a future update, but for now you
would be better off using more complete phrases in the index like 'CREATE
SERVICE' or 'DROP SERVICE'.

Why, why why...

Why do you assume that it is not documented in Books Online?
Why don't you notice that there are many index entries for SERVICE in Books
Online?
Why don't you look up SERVICE in Books Online?
Why not hone in on 'SERVICE class'?
Why not read further in Books Online about the 'SERVICE class'?
Why is it not on the Reserved Word list? (I don't know -there are many
mysteries in life...)

Why does my sending Feedback on BOL work and your attempt Fail?

And Why am I responding with so many Whys? (I don't know, it just hit me
that way...)

Why?

--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous

On Wed, 1 Nov 2006 16:02:07 -0800, "Gail Erickson [MS]"
online.microsoft.com> wrote:

That is fine when you already have some idea about what SERVICE is
about. If the point is to find out what SERVICE is about that
approach is not possible.

Roy Harvey
Beacon Falls, CT

On Wed, 1 Nov 2006 16:03:51 -0800, "Arnie Rowland" 1568.com>
wrote:

In my case because I don't use a Microsoft email client, or anything
like one. If I want to provide feedback I have to find the matching
page on the web copy of the docs and add my feedback there.

Roy

Gail,

You might want to cancel that. SERVICE isn't a keyword (*) and it is SSMS that has it the wrong way.
Check out Roger Wolters book on SB, page 59-60 and you'll see that they designed it so that some of
the new language constructs aren't actually keywords. Roger talks about SEND and RECEIVE but SERVICE
seems to be in that category. In below script, there is no error message, even though I'm not
delimiting the word SERVICE:

USE tempdb
CREATE TABLE SERVICE (c1 int)
SELECT * FROM SERVICE

(*) One could of course get into the debate of what a keyword really is. I don't know, perhaps a
keyword can work as an un-qualified identifier, while others can't. I'll leave that for you to
investigate. :-)

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/

"Gail Erickson [MS]" online.microsoft.com> wrote in message
news:urgXkIh$GHA.1220@TK2MSFTNGP04.phx.gbl...

Thanks Tibor. My follow-up investigation arrived at the same conclusion :>)

--
Gail Erickson [MS]
SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights
Download the latest version of Books Online from
http://www.microsoft.c...

Tibor Karaszi (tibor_please.no.email_karaszi@hotmail.nomail.com) writes:

It's out? Why didn't anyone tell me? Where is the nearest bookstore?

I would call them "unreserved keywords". That is, tokens that still are
legal as identifiers. T-SQL is completely diluted with them. And it's
nothing that started with SQL 2005. A very old one is OUTPUT.

An editor that is not syntax-aware does of course have the ghost of the
chance of getting it right. The best is probably to colour, unless the
keyword is really obscure.

--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se