Re: MSDE newbie

The problem is that there are spaces in the pathname, if you could get
around this you should use a simple path which doesn´t contain any space
perhaps c:\sql. If you can´t you have to doublequote the Quotes.

HTH, Jens Suessmeyer.

---
http://www.sqlserver2005.de
---


"João Costa" <JooCosta@xxxxxxxxxxxxxxxxxxxxxxxxx> schrieb im Newsbeitrag
news:6A7F0B79-0B83-46C3-A1D6-C48EB86E0C8B@xxxxxxxxxxxxxxxx
> thanks, now I have unather problem, I transcribed the line below:
> osql -E -Q "EXEC sp_attach_db N'Northwind', N'c:\SQL Server 2000 Sample
> Databases\northwind.mdf'" -S.\MOC
> the answer was:
> Msg 5105, Level 16, State 4, Server RAINBOWARRIOR\MOC, Line 1
> Device activation error. The physical file name 'c:\SQL Server 2000 Sample
> Databases\northwind.mdf' may be incorrect.
>
> "Jens Süßmeyer" wrote:
>
>> You did not specify th instance you want to connect to, this can be done
>> with the switch -S
>>
>> osql -E -Q "EXEC sp_attach_db N'Northwind', N'c:\SQL Server 2000 Sample
>> Databases\northwind.mdf' -SServername\Instancename
>>
>> Would be on the the local server ".\MOC"
>>
>> HTH, Jens Suessmeyer.
>>
>> ---
>> http://www.sqlserver2005.de
>> ---
>>
>>
>> "João Costa" <JooCosta@xxxxxxxxxxxxxxxxxxxxxxxxx> schrieb im Newsbeitrag
>> news:520F0379-78B1-449C-9864-896E04C5C910@xxxxxxxxxxxxxxxx
>> >I Just installed MDSE2000A (ithink it already comes with SP3a), by doing
>> > Setup.exe /qb+ INSTANCENAME=MOC DISABLENETWORKPROTOCOLS=1 SAPWD=moc
>> > I downloaded the northwind database and tried to install it by doing
>> > osql -E -Q "EXEC sp_attach_db N'Northwind', N'c:\SQL Server 2000 Sample
>> > Databases\northwind.mdf'"
>> >
>> > the response was
>> > [Shared Memory]Invalid connection.
>> > [Shared Memory]ConnectionOpen (Invalid Instance()).
>> >
>> > what have I done wrong?
>>
>>
>>


.

Relevant Pages