Saturday, February 25, 2012

problem using OSQL -E

Hi..
I try to connect sql server. I have installed a sql server
1. SELFPACEDSQL
2. an instance with name MyNamedInstance
I am trying to follow the sertification book page number: 95 Chapter 3.
figur 3,11
I got this message when I try to execute following commands:
C:\Documents and Settings\Administrator>OSQL -E
1> SELECT @.@.SELFPACEDSQL
2> SELECT @.@.VERSION
3> GO
Msg 137, Level 15, State 2, Server SELFPACEDSQL, Line 2
Must declare the variable '@.@.SELFPACEDSQL'.
1>
And when I write this I got this:
C:\Documents and Settings\Administrator>OSQL -L
Servers:
(local)
SELFPACEDSQL\MYNAMEDINSTANCE
C:\Documents and Settings\Administrator>
Do I do something wrong.
My computer name is: SelfPacedSQL.SelfPacedCPU
Domain: SelfPacedCPUTry with that:
OSQL -E -SSELFPACEDSQL\MYNAMEDINSTANCE
May the forces be with you.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--
"dreamlearn_ms" <dreamlearn@.yahoo.no> schrieb im Newsbeitrag
news:%23j3SDZiZFHA.3320@.TK2MSFTNGP12.phx.gbl...
> Hi..
> I try to connect sql server. I have installed a sql server
> 1. SELFPACEDSQL
> 2. an instance with name MyNamedInstance
> I am trying to follow the sertification book page number: 95 Chapter 3.
> figur 3,11
> I got this message when I try to execute following commands:
>
> C:\Documents and Settings\Administrator>OSQL -E
> 1> SELECT @.@.SELFPACEDSQL
> 2> SELECT @.@.VERSION
> 3> GO
> Msg 137, Level 15, State 2, Server SELFPACEDSQL, Line 2
> Must declare the variable '@.@.SELFPACEDSQL'.
> 1>
> And when I write this I got this:
> C:\Documents and Settings\Administrator>OSQL -L
> Servers:
> (local)
> SELFPACEDSQL\MYNAMEDINSTANCE
> C:\Documents and Settings\Administrator>
> Do I do something wrong.
> My computer name is: SelfPacedSQL.SelfPacedCPU
> Domain: SelfPacedCPU
>

No comments:

Post a Comment