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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Moving indexes!

Author  Topic 

Gopher
Yak Posting Veteran

83 Posts

Posted - 2007-11-12 : 06:54:16
Hi All

I am looking to move indexes from one table in one database to a similar table in another. Is there an easy way of doing this or do I have to create the indexes manually?

Thanks in advance!

Phil

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2007-11-12 : 06:56:24
Script all the indexes you wish from source DB and make appropriate changes like table name, index fields and execute the script on destination DB.

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"
Go to Top of Page
   

- Advertisement -