I have the professional version of sql server 2005 installed on my laptop at
work.

This installlation does not recognize -- as a comment. This version of sql
server 2005 thinks it is code. My installation of sql servert 2005 does
recognize
/* */ as a comment.

Can you tell me what I need to do so that my professioanl version of sql
sql server 2005 recognizes,
-- as a comment.

Thanks!

Hi Wendy Elizabeth

There is no such thing as a 'Professional' edition of SQL Server.

The following will you show you what edition you are running:
select serverproperty('edition')

All editions should support the -- comments. What tool are you using? Can
you give us a short example of what happens when comments are ignored, i.e.
show us the exact code entered and what you get back?
--
HTH
Kalen Delaney, SQL Server MVP
www.InsideSQLServer.com
http://sqlblog.com


"Wendy Elizabeth" <WendyElizabeth@discussions.microsoft.com> wrote in
message news:CC2B2782-A761-4D39-B7C6-C2FF8F196B02@microsoft.com...
>I have the professional version of sql server 2005 installed on my laptop
>at
> work.
>
> This installlation does not recognize -- as a comment. This version of sql
> server 2005 thinks it is code. My installation of sql servert 2005 does
> recognize
> /* */ as a comment.
>
> Can you tell me what I need to do so that my professioanl version of sql
> sql server 2005 recognizes,
> -- as a comment.
>
> Thanks!