>>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 WizardThank you, Naomi.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham