Insert other db problem

Hello
I get incorrect syntax ner '100' on this one :(
INSERT INTO 100Test.myuser.Test
(Something)
SELECT Something FROM TestDB
why?
TIA
/LasseTry this:
INSERT INTO [100Test].myuser.Test
(Something)
SELECT Something FROM TestDB
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Lasse Edsvik" <lasse@.nospam.com> wrote in message
news:uXVjK$HMFHA.2132@.TK2MSFTNGP14.phx.gbl...
Hello
I get incorrect syntax ner '100' on this one :(
INSERT INTO 100Test.myuser.Test
(Something)
SELECT Something FROM TestDB
why?
TIA
/Lasse|||Look for "Rules for Regular Identifiers" in BOL.
AMB
"Lasse Edsvik" wrote:

> Hello
> I get incorrect syntax ner '100' on this one :(
> INSERT INTO 100Test.myuser.Test
> (Something)
> SELECT Something FROM TestDB
> why?
> TIA
> /Lasse
>
>|||Try:
INSERT INTO [100Test].myuser.Test
Use [] if the database name starts with a number
"Lasse Edsvik" wrote:

> Hello
> I get incorrect syntax ner '100' on this one :(
> INSERT INTO 100Test.myuser.Test
> (Something)
> SELECT Something FROM TestDB
> why?
> TIA
> /Lasse
>
>|||Invalid objectname '100Test.myuser.Test'
the db and table is there on same server..... and user has rights to that
table...... sigh..... not sure how such a simple thing can go wrong....
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
news:%2309qXCIMFHA.3548@.TK2MSFTNGP10.phx.gbl...
> Try this:
> INSERT INTO [100Test].myuser.Test
> (Something)
> SELECT Something FROM TestDB
>
> --
> HTH,
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>
> "Lasse Edsvik" <lasse@.nospam.com> wrote in message
> news:uXVjK$HMFHA.2132@.TK2MSFTNGP14.phx.gbl...
> Hello
> I get incorrect syntax ner '100' on this one :(
> INSERT INTO 100Test.myuser.Test
> (Something)
> SELECT Something FROM TestDB
> why?
> TIA
> /Lasse
>
>|||The rule of identifiers state that the first character of an object name
should be a letter, underscore (_), "at" sign (@.), or number sign (#). If
any other characters occur, then you will have to use it as a delimited
identifier as [100Test] or "100Test".
Anith|||Now it "works".....
rows get inserted but i get this error:
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionCheckForData
(CheckforData()).
Server: Msg 11, Level 16, State 1, Line 0
General network error. Check your network documentation.
Connection Broken
hmm?
"Lasse Edsvik" <lasse@.nospam.com> wrote in message
news:uXVjK$HMFHA.2132@.TK2MSFTNGP14.phx.gbl...
> Hello
> I get incorrect syntax ner '100' on this one :(
> INSERT INTO 100Test.myuser.Test
> (Something)
> SELECT Something FROM TestDB
> why?
> TIA
> /Lasse
>