all groups > sql server connect > may 2005 >
You're in the

sql server connect

group:

problem using OSQL -E



problem using OSQL -E dreamlearn_ms
5/31/2005 11:20:47 PM
sql server connect: 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

Re: problem using OSQL -E Jens Süßmeyer
6/1/2005 12:07:50 AM
Try 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...
[quoted text, click to view]

AddThis Social Bookmark Button