>>http://blogs.lessthandot.com/index.php/DataMgmt/DBAdmin/MSSQLServerAdmin/how-to-move-datafiles-to-a-new-drive-in
>>
>>

>>
>>SELECT name, physical_name AS CurrentLocation, state_desc
>>
>>FROM sys.master_files
>>
>>WHERE database_id = DB_ID(N'MyDbName');

>
>Thank you.

BTW, just checked one of my databases and was very surprised to find out where it's located - not where I thought it was supposed to be.