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

The client has to have SQL Express installed, but after that all you need to do is what you did on your own box - copy the data files and attach them to the server.

You can also do it by running scripts created either in your own management studio or with tools like the ones from RedGate to create the database and its objects on the other server. ( if you just want empty data MS created scripts are easy. Scripting the actual data a little trickier and a lot easier with 3rd party tools - but you can also just copy the whole database from yours to theirs as outlined above )



Google it and you'll find all kinds of stuff. There's a lot of information on this stuff all over the web.


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