SQL 2000 - Cannot "USE database" - Incorrect Syntax??

Hello,

First off I want to say that I am a "noob" when it comes to MS SQL. I
have an odd issue. I have a database that's called 001 - When issue the
command "use 001" in Query Analyzer, I get the error "server: msg 170,
level 15" Syntax incorrect by 001.

The database exists! if I do a "SP_databases" the database does show up
as 001. Why can I not use it?

Thanks in advanced.

USE [001]

The standard for names requires the first character be alphabetic.  A
name that voilates that must be put in square brackets.  I strongly
suggest that since you are just getting started you use name that fits
the standard.

Roy Harvey
Beacon Falls, CT

On 29 Nov 2006 17:44:40 -0800, patrick.mcdonald@gmail.com wrote:

>Hello,
>
>First off I want to say that I am a "noob" when it comes to MS SQL. I
>have an odd issue. I have a database that's called 001 - When issue the
>command "use 001" in Query Analyzer, I get the error "server: msg 170,
>level 15" Syntax incorrect by 001.
>
>The database exists! if I do a "SP_databases" the database does show up
>as 001. Why can I not use it?
>
>Thanks in advanced.

Thanks alot that helps!

Patrick


Roy Harvey  wrote:[color=darkred
]
> USE [001]
>
> The standard for names requires the first character be alphabetic.  A
> name that voilates that must be put in square brackets.  I strongly
> suggest that since you are just getting started you use name that fits
> the standard.
>
> Roy Harvey
> Beacon Falls, CT
>
> On 29 Nov 2006 17:44:40 -0800, patrick.mcdonald@gmail.com wrote:
>