>Is there an SQL command I can use to change the data directory of a database?
>By default to database is crated in C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\ and that is in "violation" with Vista rulez.
>
>I know I can specify the path when I create the database, but is there a vay to change the path after the database has been created.
>
>Thanks,
>Einar
Can't you detach it, move it then attach it again? There may be a live way but this is what I have done. Might not be great for a a database that can't be down.
Timothy Bryan