Indexes

How can i send Indexes of all table in the sql database to a text file
--
Yousuf Khan
ProgrammerHi,
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 script
s
> for any objects in the DB.
> Select Only the script indexes option so u will have the script only for a
ll
> indexes and save this to a file.
> any questions le me know.
> --
> Herbert
>
> "Yousuf" wrote:
>