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
>
>