retrieving the number of rows o feach table of each DB?

Hi,
I want to monitor the number of rows of all my databases.
any simple way to do this?
also, if I can, I want the table size in bytes etc...
the result will be stored in a table for historical monitoring and
statistics.
the SQLH2 tool monitor only file size, not at the table level.
any guide?
thanks.
Jerome.Take a look at sp_spaceused
http://sqlservercode.blogspot.com/
"Jéjé" wrote:
> Hi,
> I want to monitor the number of rows of all my databases.
> any simple way to do this?
> also, if I can, I want the table size in bytes etc...
> the result will be stored in a table for historical monitoring and
> statistics.
> the SQLH2 tool monitor only file size, not at the table level.
> any guide?
> thanks.
> Jerome.
>
>|||Hi,
See the below URL:-
http://www.aspfaq.com/show.asp?id=2428
Thanks
Hari
SQL Server MVP
"Jéjé" <willgart@.BBBhotmailAAA.com> wrote in message
news:ePvT5eCzFHA.3188@.TK2MSFTNGP14.phx.gbl...
> Hi,
> I want to monitor the number of rows of all my databases.
> any simple way to do this?
> also, if I can, I want the table size in bytes etc...
> the result will be stored in a table for historical monitoring and
> statistics.
> the SQLH2 tool monitor only file size, not at the table level.
> any guide?
> thanks.
> Jerome.
>

retrieving the number of rows o feach table of each DB?

Hi,
I want to monitor the number of rows of all my databases.
any simple way to do this?
also, if I can, I want the table size in bytes etc...
the result will be stored in a table for historical monitoring and
statistics.
the SQLH2 tool monitor only file size, not at the table level.
any guide?
thanks.
Jerome.Take a look at sp_spaceused
http://sqlservercode.blogspot.com/
"Jéjé" wrote:

> Hi,
> I want to monitor the number of rows of all my databases.
> any simple way to do this?
> also, if I can, I want the table size in bytes etc...
> the result will be stored in a table for historical monitoring and
> statistics.
> the SQLH2 tool monitor only file size, not at the table level.
> any guide?
> thanks.
> Jerome.
>
>|||Hi,
See the below URL:-
http://www.aspfaq.com/show.asp?id=2428
Thanks
Hari
SQL Server MVP
"Jj" <willgart@.BBBhotmailAAA.com> wrote in message
news:ePvT5eCzFHA.3188@.TK2MSFTNGP14.phx.gbl...
> Hi,
> I want to monitor the number of rows of all my databases.
> any simple way to do this?
> also, if I can, I want the table size in bytes etc...
> the result will be stored in a table for historical monitoring and
> statistics.
> the SQLH2 tool monitor only file size, not at the table level.
> any guide?
> thanks.
> Jerome.
>

retrieving the number of rows o feach table of each DB?

Hi,
I want to monitor the number of rows of all my databases.
any simple way to do this?
also, if I can, I want the table size in bytes etc...
the result will be stored in a table for historical monitoring and
statistics.
the SQLH2 tool monitor only file size, not at the table level.
any guide?
thanks.
Jerome.
Take a look at sp_spaceused
http://sqlservercode.blogspot.com/
"Jéjé" wrote:

> Hi,
> I want to monitor the number of rows of all my databases.
> any simple way to do this?
> also, if I can, I want the table size in bytes etc...
> the result will be stored in a table for historical monitoring and
> statistics.
> the SQLH2 tool monitor only file size, not at the table level.
> any guide?
> thanks.
> Jerome.
>
>
|||Hi,
See the below URL:-
http://www.aspfaq.com/show.asp?id=2428
Thanks
Hari
SQL Server MVP
"Jj" <willgart@.BBBhotmailAAA.com> wrote in message
news:ePvT5eCzFHA.3188@.TK2MSFTNGP14.phx.gbl...
> Hi,
> I want to monitor the number of rows of all my databases.
> any simple way to do this?
> also, if I can, I want the table size in bytes etc...
> the result will be stored in a table for historical monitoring and
> statistics.
> the SQLH2 tool monitor only file size, not at the table level.
> any guide?
> thanks.
> Jerome.
>
sql