>>Is there an SQL command I can use to change the data directory of a database?
>
>I think you'll have to detach the database, physically move the files manually, then reattach. If there's another way, I'm all ears...

Thanks for the reply. That is a good approach