Re: create database 2bad - - Fails?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: oj (nospam_ojngo_at_home.com)
Date: 06/08/04 

Date: Tue, 8 Jun 2004 15:27:19 -0700

This is by design. You must follow unique identifier rule for naming.

http://msdn.microsoft.com/library/en-us/acdata/ac_8_con_03_6e9e.asp

The first character must be one of the following:
  a.. A letter as defined by the Unicode Standard 2.0. The Unicode
definition of letters includes Latin characters from a through z and from A
through Z, in addition to letter characters from other languages.

If you must use # as the first letter, you could enclose the name in []
bracket.

e.g.
create database [123abc]

"Yaiz" <anonymous@discussions.microsoft.com> wrote in message
news:807AD1A3-B57C-46A2-859D-A57BF4E7E2D4@microsoft.com...
> The following commands fail in the SQL query Analzyer
>
> Command,
> create database 2bad
>
> Error,
> Server: Msg 170, Level 15, State 1, Line 1
> Line 1: Incorrect syntax near '2'.
>
> Command,
> create database too bad
>
> Error,
> Server: Msg 170, Level 15, State 1, Line 1
> Line 1: Incorrect syntax near 'bad'.
>
> Why?
>
> create database v2bad, works correctly
>
> Thanks for your help

Relevant Pages

  • Re: Set App Priority
    ... string and then terminates" ... gives then parameters to use to modify the START command ... below) /F:OFF Disable file and directory name completion characters ... no special characters between the two quote characters, ...
    (microsoft.public.windowsxp.customize)
  • Re: Set App Priority
    ... This would start notepad with high priority. ... Starts a new instance of the Windows XP command interpreter ... /F:OFF Disable file and directory name completion characters ... If all of the following conditions are met, then quote characters ...
    (microsoft.public.windowsxp.customize)
  • Re: DOS Box Keyboard problem
    ... I get 437 from command chcp and cmd chcp. ... When in the cmd box I can type with all characters OK ... The OEMCP value controls to which OEM code page to translate ANSI, ...
    (microsoft.public.windowsxp.configuration_manage)
  • Re: Loading a data file containing character fields with different encodings
    ... The data is coming from one database that contains UTF-8 characters and it appears that he's attempting to load ... UTF-8 characters along with Latin-1 characters. ... it would be just as easy to write the loader script that converts the encoding to a "unicode" intermediate format and then load with the correct database encoding. ...
    (comp.databases.informix)
  • Re: Loading a data file containing character fields with different encodings
    ... The data is coming from one database that contains UTF-8 characters and it appears that he's attempting to load ... UTF-8 characters along with Latin-1 characters. ... it would be just as easy to write the loader script that converts the encoding to a "unicode" intermediate format and then load with the correct database encoding. ...
    (comp.databases.informix)