How can I get the result of SP_Help myTable

Hi,
Since "Sp_help myTable" will give different rows of result, so I could not
run like
"insert into aTable exec sp_help myTable" to get the result of sp_help for
analysing. How could I get the result and analysing it?
And also, I remember that in the past, I could check the code of sp_help to
get some help for doing the same task that sp_help does, but now, I could
not find the definition of sp_help.
Thanks for any advice
Frank
Hi Frank
The definitions of the system stored procedures are all available in the
master database and can be viewed using sp_helptext.
USE master
EXEC sp_helptext sp_help
Since sp_help returns multiple results sets, it will be difficult to put the
results all into one table.
You could take the code of sp_help and create a new proc that takes each
result set and puts it into a separate table.
HTH
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Frank" <wangping@.lucent.com> wrote in message
news:Obn7NgwPFHA.2652@.TK2MSFTNGP10.phx.gbl...
> Hi,
> Since "Sp_help myTable" will give different rows of result, so I could not
> run like
> "insert into aTable exec sp_help myTable" to get the result of sp_help for
> analysing. How could I get the result and analysing it?
> And also, I remember that in the past, I could check the code of sp_help
> to
> get some help for doing the same task that sp_help does, but now, I could
> not find the definition of sp_help.
> Thanks for any advice
> Frank
>
|||Thanks Kalen,
That's what I want.
B/R
Frank
"Kalen Delaney" <replies@.public_newsgroups.com> wrote in message
news:ehcxCjwPFHA.1172@.TK2MSFTNGP12.phx.gbl...
> Hi Frank
> The definitions of the system stored procedures are all available in the
> master database and can be viewed using sp_helptext.
>
> USE master
> EXEC sp_helptext sp_help
> Since sp_help returns multiple results sets, it will be difficult to put
the[vbcol=seagreen]
> results all into one table.
> You could take the code of sp_help and create a new proc that takes each
> result set and puts it into a separate table.
> --
> HTH
> --
> Kalen Delaney
> SQL Server MVP
> www.SolidQualityLearning.com
>
> "Frank" <wangping@.lucent.com> wrote in message
> news:Obn7NgwPFHA.2652@.TK2MSFTNGP10.phx.gbl...
not[vbcol=seagreen]
for[vbcol=seagreen]
could
>