>Hi,
>
>I have asked this questions some long time ago. The question was/is, I have an existing database in the SQL Server 2005. I want to add a new database to the SQL Server of the same structure but empty. The notes I took back then from the suggestions given to me were the following:
>
>Right click on a DB and select Script Database AS, CREATE TO FILE.
>
>But when I follow the step above and look at the script I see nothing about the tables that the script should have. Am I missing something in the above step?
>
>TIA.
Right click on the database, Tasks, Generate Scripts and then follow the Wizard.
See this good tutorial
Generate Script with data from database using Publishing Wizard
If it's not broken, fix it until it is.
My Blog