>Hi.
>I've just created a Databse with a few tables in MS Sql Management studio.
>I have another Database whree it is quite clear where it resides, e.g. c:\myfolder\MYDB.MDF but this Databse just give the name of the database, and I dont know where it is stored?
>How can I find out where it is , and I want to tmove it to another folder
>Regards,
>Gerard

In management studio, right click on the database in object explorer pane and then click on the 'Files' option in the 'Select a Page' pane of the Database Properties window. You may need to scroll to the right to see the paths for the files in the 'Database Files' grid.