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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2007-02-15 : 09:22:55
|
| ALI writes "I need to write a sql script that reads system tables to find out about all indexes on a particular database. I got to a level of finding the index name. Now I want to backup this index in some format so that if required I can apply these indexes. My problem is as I have 100s of tables and 100s of indexes, can I write a sql stored proc that takes table name as input and backsup the indexes on that table so that if required can be applied back?" |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-02-15 : 10:09:13
|
there's no such thing as index backup AFAIKGo with the flow & have fun! Else fight the flow  blog thingie: http://weblogs.sqlteam.com/mladenp |
 |
|
|
|
|
|
system index information