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:
> 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