In an attempt to move my DB to a new server I had to run the script from cmd prompt and forgot to assign the DB name and all my tables were created under master. Is it possible to move these tables to a different DB or do I need to rerun the script?
+2
A:
You would need to rerun the script.
There is no way to move tables between databases.
Martin Smith
2010-09-01 15:14:23
+1, @vbNewbie, you already have a working script, just re-run it. Make sure you drop all the junk you added to master though
KM
2010-09-01 15:23:00