Indexes

How can i send Indexes of all table in the sql database to a text file
Yousuf Khan
Programmer
Hi,
By using the generate sql script option we will be able to generate scripts
for any objects in the DB.
Select Only the script indexes option so u will have the script only for all
indexes and save this to a file.
any questions le me know.
Herbert
"Yousuf" wrote:

> How can i send Indexes of all table in the sql database to a text file
> --
> Yousuf Khan
> Programmer
|||Hi Herbert
You can also run a small select statement againt sysindexes table and save
the output to a text file.
Someting like:
sp_MSForEachTable 'exec sp_helpindex ''?'''
Good luck
JP
"Herbert" wrote:
[vbcol=seagreen]
> Hi,
> By using the generate sql script option we will be able to generate scripts
> for any objects in the DB.
> Select Only the script indexes option so u will have the script only for all
> indexes and save this to a file.
> any questions le me know.
> --
> Herbert
>
> "Yousuf" wrote: