>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