Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Create a database from a script
Message
General information
Forum:
Microsoft SQL Server
Category:
Other
Environment versions
SQL Server:
SQL Server 2005
Miscellaneous
Thread ID:
01432247
Message ID:
01432259
Views:
26
>Then you may have trouble to run the script and create everything in master DB :-)
>You must gave at least ONE:
>
>USE YourDataBaseName
>GO
>
>at the beginning of the script.
>
>BTW You can't create a new database in place of some old one before dropping it first (I talk about the recreate DB from scratch).
>So make sure yo first BACKUP your old DB. DROP it and then run script to create it anew.


Good point about adding line "USE YourDatabaseName" to the script. Thank you.
"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
Previous
Reply
Map
View

Click here to load this message in the networking platform