Error creating DB with numerical name?

Hi, all!! Using SQL 2000, latest patches and such; running under Win2k,
latest patches.
When I try to create a database with a numerical name (such as "12345"), I'm
getting an Incorrect Syntax error in code code (script) and in the Query
Analyzer. However, EntMgr will create it perfectly...
I just know this is going to be something simple, but derned if I can see
it... any ideas' :)
Thanks,
JackHi Jack
Put square brackets around any identifiers that don't follow the normal
rules for identifiers. (The normal rule for the identifies says they must
start with a letter, or one of a very few special chars, but not numbers.)
CREATE DATABASE [12345]
--
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Jack Black" <jackblackisback@.hotmail.com> wrote in message
news:OKH7EKusDHA.2932@.TK2MSFTNGP11.phx.gbl...
> Hi, all!! Using SQL 2000, latest patches and such; running under Win2k,
> latest patches.
> When I try to create a database with a numerical name (such as "12345"),
I'm
> getting an Incorrect Syntax error in code code (script) and in the Query
> Analyzer. However, EntMgr will create it perfectly...
> I just know this is going to be something simple, but derned if I can see
> it... any ideas' :)
> Thanks,
> Jack
>|||To add to Kalen's comments:
You might want to re-think this. Most developers stay away from names that doesn't confirms to the
rules for standard identifiers, as you have to always mess about with delimiters for the name when
you work against the data (and sooner or later you come across this great tools which doesn't
support delimited identifiers).
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Jack Black" <jackblackisback@.hotmail.com> wrote in message
news:OKH7EKusDHA.2932@.TK2MSFTNGP11.phx.gbl...
> Hi, all!! Using SQL 2000, latest patches and such; running under Win2k,
> latest patches.
> When I try to create a database with a numerical name (such as "12345"), I'm
> getting an Incorrect Syntax error in code code (script) and in the Query
> Analyzer. However, EntMgr will create it perfectly...
> I just know this is going to be something simple, but derned if I can see
> it... any ideas' :)
> Thanks,
> Jack
>

Error after Windows Update

Hi to all,
i have a win2k machine with sql server 7 on it, that is beeing fed with
data by another one, using replication.
The other machine is an sql server 2k and is the Publisher of the
replication
The machine with sql server 7, needed a windows update and so i did it this
morning.
After the reboot, the Publisher machine cannot push data to sql 7,and it
displays the
following error :
"Unable to find the remote agent on the remote server. Upgrade SQL server on
the Subscriber if version is <= 7.0 or rerun SQL Server setup on the remote
server. The step failed."
Agent is of cource running on the sql 7 machine.
Does anyone else has encountered this ?
Thanks a lot for any help,
anthony
what is the db compatibility mode on the subscriber in the subscription
database?
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"objectref" <objectref@.mediatrel.com> wrote in message
news:uR4tgdV%23EHA.1260@.TK2MSFTNGP12.phx.gbl...
> Hi to all,
> i have a win2k machine with sql server 7 on it, that is beeing fed with
> data by another one, using replication.
> The other machine is an sql server 2k and is the Publisher of the
> replication
> The machine with sql server 7, needed a windows update and so i did it
this
> morning.
> After the reboot, the Publisher machine cannot push data to sql 7,and it
> displays the
> following error :
> "Unable to find the remote agent on the remote server. Upgrade SQL server
on
> the Subscriber if version is <= 7.0 or rerun SQL Server setup on the
remote
> server. The step failed."
> Agent is of cource running on the sql 7 machine.
>
> Does anyone else has encountered this ?
> Thanks a lot for any help,
> anthony
>