>>>>I was thinking of dropping the original database too, but perhaps we can keep the original and create a new database using the script?
>>>
>>>This is what I hope to do. I will make a backup of the existing one first, just in case.
>>
>>Right, also good point from Borislav to add USE myNewDatabase at the top of your script.
>
>Success! What surprised me is that it took (what seemed like) less than a second - very fast.
If you haven't scripted the data, then it should be very quick to create all objects.
If it's not broken, fix it until it is.
My Blog