Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
synapse
Starting Member
2 Posts |
 Posted - 2005-06-02 : 05:19:59
|
| Im a sql server 2K newbie so please pardon me if this is a stupid qeustion. Anyway here is my problem. I have a database named salesmaster, i want to create a temporary database named salesmastertemp that has the same table struture as the db salesmaster.The problem is I can't find the script that was used to create the salesmaster database. Is there a tool/procedure/method that I can use to help me do that aside from creating a totally new script? |
|
|
AndyB13
Aged Yak Warrior
583 Posts |
Posted - 2005-06-02 : 05:25:23
|
In Enterprise Manager > Right click salesmaster database > All Tasks > Generate SQL script.Select the options/objects you want to script etc and click preview or save to fileAndyBeauty is in the eyes of the beerholder  |
 |
|
|
|
|
|
creating a temp database