SQL Express 2008

When attempting to attach a db I can only see a path of user/username  and 
then the mdf has to be in that folder.  I'd like to drill down deeper.

How can I do that?

Thanks for your help. 

On Mon, 19 Jul 2010 05:50:39 -0500, "SAC" <sac@somewhere.com> wrote:

>SQL Express 2008
>
>When attempting to attach a db I can only see a path of user/username  and 
>then the mdf has to be in that folder.  I'd like to drill down deeper.
>
>How can I do that?
>
>Thanks for your help. 


If it not totally clear what you are trying to do, but when you attach
a database you can not move the location of the files as part of the
attach command, you will need to move the files before attaching.

If you had backed up the database then you can MOVE the files diuring
the restore.

John