"Sue Hoegemeier" wrote:

> You shouldn't alter any system stored procedures. However,
> you can view the code for the stored procedures and use that
> to create your own version with the modifications you want.
> To view the definition for the stored procedure you can
> execute the following in Query Analyzer:
> use master
> go
> exec sp_helptext 'sp_helpdb'
>
> -Sue
>
> On Wed, 30 Mar 2005 11:31:11 -0800, "isabelle"
> <isabelle@discussions.microsoft.com> wrote:
>
> >Hi,
> >
> >Is there any way to modify the output of sp_helpdb? Sometimes I would like
> >to run it and only see a few of the columns instead of the complete output so
> >I can save to a file for reporting purposes. Is there anyway to specify what
> >columns you want it to return instead of everything?
> >
> >Thanks!
> >Bea
>