I downloaded and installed the SQL 2005 Management Studio Express
(SQLServer2005_SSMSEE.msi)
At first could not access the Windows Internal Database, then found that one
has to connect to \\.\pipe\mssql$microsoft##ssee\sql\query on the local
machine.
That works.


"Alex" wrote:

> OK.
> Sqlcmd cannot do it. There is no attach/de-attach option.
> Probably the most practical way is:
> Download the free SQL 2005 EE CTP and connect to the local WSUS instance and
> detach and move the mdf/ldf's and reattach them.
> I found it here:
> http://www.microsoft.com/downloads/d...displaylang=en
> Thank you.
>
>
> "Lawrence Garvin" wrote:
>
> > "Alex" <Alex@discussions.microsoft.com> wrote in message
> > news:A1627E3E-9736-4D86-91DD-13EF554D2030@microsoft.com...
> > > Lawrence, Thank you for your answer. it is exactly what I want to know:
> > > moving database.
> > > I am using windows internal database and I want to move it to another HD,
> > > so
> > > I have to use Sqlcmd -deattach from one HD and attach to another.
> > > please give me exact command line of this command: I did not find
> > > deattach/attach option.
> >
> > A tutorial on how to use SQLCMD, OSQL, or SSMS is really beyond the scope of
> > this group.
> >
> > But here's a starting place for the documentation on using SQLCMD:
> > http://msdn.microsoft.com/en-us/library/ms162773.aspx
> >
> >
> >
> >
> >
> > --
> > Lawrence Garvin, M.S., MCITP(x2), MCTS(x5), MCP(x7), MCBMSP
> > Principal/CTO, Onsite Technology Solutions, Houston, Texas
> > Microsoft MVP - Software Distribution (2005-2009)
> >
> > MS WSUS Website: http://www.microsoft.com/wsus
> > My Websites: http://www.onsitechsolutions.com;
> > http://wsusinfo.onsitechsolutions.com
> > My MVP Profile: http://mvp.support.microsoft.com/pro...awrence.Garvin
> >
> >