Prev: Latvian collagtion issue
Next: Using Float Type Variables for Primary on SQL 2005
From: SAC on 19 Jul 2010 06:50
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.

From: John Bell on 19 Jul 2010 15:25
On Mon, 19 Jul 2010 05:50:39 -0500, "SAC" <sac(a)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
 | 
Pages: 1
Prev: Latvian collagtion issue
Next: Using Float Type Variables for Primary on SQL 2005