You can also use the "Copy Database" task wizard in SQL Server Management
Studio (if you are using SQL Server 2005).
--
Rubén Garrigós
Solid Quality Mentors
"Angella Andrea" <angella.andrea@hotmail.it> wrote in message
news

384E522-BA92-4966-A2C4-7D72D7F1C3E9@microsoft.com...
> Hi, how can I copy the schema and the content of tables from one database
> to another ?
>
> Thank you
>
> Andrea