Hi Charles.thanks for that.
Just one other q.. I need to 'Deploy' thsi database (and associated tables) on a cliet pc. Is there an easy way to do this without having to type all the table field specs in again ?

Regards,
Gerard



>>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
>
>Look in the Microsoft SQL Server folder under Program Files, for example
>
>C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data
>
>To move it, you will need to detach it ( right click on database in MS ) and then move the MDF and LDF files to where you want it then right click on the server to reattach it.