"Jens Süßmeyer" wrote:

> 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@discussions.microsoft.com> schrieb im Newsbeitrag
> news:6A7F0B79-0B83-46C3-A1D6-C48EB86E0C8B@microsoft.com...
> > 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@discussions.microsoft.com> schrieb im Newsbeitrag
> >> news:520F0379-78B1-449C-9864-896E04C5C910@microsoft.com...
> >> >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?
> >>
> >>
> >>
>
>