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