|
I
don't know if this is what IMail is trying to do but SQL Server won't
let you create tables with names that start wit numbers. From SQL Server
BOL:
CREATE TABLE (T-SQL)
Table names must conform to the rules for identifiers Using Identifiers
Rules for Regular Identifiers The rules for the format of regular identifiers are dependent on the database compatibility level, which can be set with sp_dbcmptlevel. For more information, see sp_dbcmptlevel. When the compatibility level is 70, the rules are: The
first character must be one of the following:
A letter as defined by the Unicode Standard 2.0. The Unicode definition of letters includes Latin characters a-z and A-Z, in addition to letter characters from other languages. The _ (underscore), @ (at sign), or # (number sign) symbol. Certain symbols at the beginning of an identifier have special meaning in SQL Server. An identifier beginning with @ denotes a local variable or parameter. An identifier beginning with # denotes a temporary table or procedure. An identifier beginning with double number signs (##) denotes a global temporary object. Some
Transact-SQL functions have names that start with double at signs (@@). To avoid
confusion with these functions, it is recommended that you do not use names that
start with @@.
Subsequent characters can be:
Letters as defined in the Unicode Standard 2.0. Decimal numbers from either Basic Latin or other national scripts. The @, $, #, or _ symbols. The identifier must not be a Transact-SQL reserved word. SQL Server reserves both the uppercase and lowercase versions of reserved words. Embedded spaces or special characters are not allowed. Cheers,
Andrew Coates
|
- [IMail Forum] Domains beginning with a number Brian McCarty
- Fw: [IMail Forum] Domains beginning with a number Brian McCarty
- Andrew Coates
