I know lots of you know this, but let me share it
First go to your database,
Login then
Right click your Database, e.g. (RanGame1)
Choose task, under Task, Choose Generate Script
then Next until it finish generating script.
Then one of the step asking for the path of the output script.
Change it if you like to change the output path and name..
After Generating the script go to the path where you put the output file.
Open it, then delete the existing database(in this Example delete RanGame1)(do it on your on risk), after deleting execute the generated script..
then you have your fresh database.
First go to your database,
Login then
Right click your Database, e.g. (RanGame1)
Choose task, under Task, Choose Generate Script
then Next until it finish generating script.
Then one of the step asking for the path of the output script.
Change it if you like to change the output path and name..
After Generating the script go to the path where you put the output file.
Open it, then delete the existing database(in this Example delete RanGame1)(do it on your on risk), after deleting execute the generated script..
then you have your fresh database.
Attachments
You must be registered for see attachments list