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 |
|
oana4
Starting Member
3 Posts |
 Posted - 2004-11-30 : 15:24:29
|
| Hi,How can I find all the indexes from a database - with the body creation - and to create these indexes in another database?Thanks. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-11-30 : 15:29:11
|
| Just generate the scripts from Enterprise Manager. Right click on your database, all tasks, generate SQL script. Make sure to select the option to script indexes on the third tab. Then modify the file to get rid of the dropping and creating of tables. Then run your script on the other database.Tara |
 |
|
|
|
|
|
Recreate the indexes