This is how I created the script. But the script does not have the database name; it only has code to create all objects for the database. So, as Boris suggested, I need to add this line.
>I don't have SQL Server 2005 (only 2008), but can't you right-click on the database in the Management Studio (or whatever it's called in 2005) and select "Script Database as | Create to"? You could them modify the name of the database and run the script.
>
"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