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 |
|
tcolwell
Starting Member
1 Post |
 Posted - 2006-07-07 : 10:08:14
|
| WE have a database named DM on a test system and production system. All the indexes got lost in the test system somehow. Is there a way i can copy the indexes from the production system to the test system like I know you can with data?ThanksTricia Colwell |
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2006-07-07 : 10:30:17
|
| You can script and recreate the indexes. Go into enterprise manager on the prod box, and right click on the database. Choose all tasks, generate SQL Script. Then just tick "all tables". In formatting deslect everything, and in options tick "script indexes". Then go back to general and click "preview". Copy the data in the clipboard and use appropriately.-------Moo. :) |
 |
|
|
|
|
|
Copying Indexes