>>>>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.
>>>
>>>See
Change database directory Thread #
1348788>>
>>Thanks Sergey. That is acctually the thread that got me thinking about this. Do you know the syntax off the top of your head?
>
>That's what BOL is for. See
Moving User DatabasesThanks Sergey. Thanks for the link. It is just what I need.
Semper ubi sub ubi.